Im putting together a list and I need some assistance.
In cell A1 I have a phone number. 2125551212 for example.
I need it to look like 12125551212 - it needs to have a one in front on
it.
I have an excel list of over 20000 numbers. Is there a way to easily
put a 1 in front of all the numbers?


--
alexm999
------------------------------------------------------------------------
alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918
View this thread: http://www.excelforum.com/showthread...hreadid=485001

insert a column after "a" in new column "b'' type in '=1&a1'

then fill down entire list.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=485001

In B1 put

=1&A1

and then copy down. Lastly copy Col B, and paste special as values and then
delete Col A

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------




"alexm999" wrote in
message ...

Im putting together a list and I need some assistance.
In cell A1 I have a phone number. 2125551212 for example.
I need it to look like 12125551212 - it needs to have a one in front on
it.
I have an excel list of over 20000 numbers. Is there a way to easily
put a 1 in front of all the numbers?


--
alexm999
------------------------------------------------------------------------
alexm999's Profile:
http://www.excelforum.com/member.php...fo&userid=4918
View this thread: http://www.excelforum.com/showthread...hreadid=485001

or insert macro

Sub AddOne()

ActiveCell.FormulaR1C1 = "=1&RC[-1]"
Range("B1:B20000").Select
Selection.FillDown
End Sub


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=485001

Assuming all your phone numbers are this format, then yes there is an easy
way to do this.

1. In any empty cell, enter the value: 10000000000
2. Copy that cell
3. Highlight your list of phone numbers
4. Select "Paste Special..." from the Edit Menu
5. Click the box labeled "Add" in the Operation section
6. Click "OK"
7. Delete the 10000000000 from the cell that you entered earlier.=

That should do it.

"alexm999" wrote:


Im putting together a list and I need some assistance.
In cell A1 I have a phone number. 2125551212 for example.
I need it to look like 12125551212 - it needs to have a one in front on
it.
I have an excel list of over 20000 numbers. Is there a way to easily
put a 1 in front of all the numbers?


--
alexm999
------------------------------------------------------------------------
alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918
View this thread: http://www.excelforum.com/showthread...hreadid=485001

Hi Alex. In B1 type "=1&A1. This will put a 1 in front of the number in A1.
Then just copy down for your 20,000 entries. When finished copy Column B on
itself, using Edit - Paste Special - Values. HTH
--
Sincerely, Michael Colvin


"alexm999" wrote:


Im putting together a list and I need some assistance.
In cell A1 I have a phone number. 2125551212 for example.
I need it to look like 12125551212 - it needs to have a one in front on
it.
I have an excel list of over 20000 numbers. Is there a way to easily
put a 1 in front of all the numbers?


--
alexm999
------------------------------------------------------------------------
alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918
View this thread: http://www.excelforum.com/showthread...hreadid=485001

Im putting together a list and I need some assistance.
In cell A1 I have a phone number. 2125551212 for example.
I need it to look like 12125551212 - it needs to have a one in front on
it.
I have an excel list of over 20000 numbers. Is there a way to easily
put a 1 in front of all the numbers?

One way is to select the column and use:
Format Cells Number
Then for "Category" select "Custom" and put this for the "Type":
1##########