| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
That did it!!!
Thank you very much, I appreicate it. "Jason Morin" wrote: Oh, I bet your original numbers are actually text. To convert them to numbers, type the number 1 into a open cell, copy it, select your column of numbers, and do Edit Paste Special Multiply. Now copy them over to the formatted column using Paste Special Values. Jason -----Original Message----- Hi Jason, thanks for helping me, I appreciate it. When I say "move the old numbers" I mean that I created a new column with the phone number format selected through excels' cell format function. I then, as you suggested, would copy the old column of numbers and do copy then paste special then Values etc. The numbers remain in the old format however, ########## and not ###-###-####. I have also tried the custom format as well, can't seem to get that to work either. I know the format on the new column is working since when I manually type in a phone number, the format automatically changes it to the correct ###-###-#### format. Any other thoughts? Thanks again! "Jason Morin" wrote: What do you mean by "move the old number"? Copy the column of numbers, select the formatted column, and go to Edit Paste Special Value. HTH Jason Atlanta, GA -----Original Message----- Greetings: I would like to convert a column of telephone numbers that are currently in the format of: ########## to the format of: ###-###- ####. I have added a column next to the existing phone number column with the new format listed above, but when I move the old number to the new number, the format does not change. It will only change to the new format if I manually enter in each number. Does anyone know how I could convert the existing numbers to the above telephone format? Thanks in advance for your help! . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save a new number format for other worksheets | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| how do you format a number such as 6.9 if you want the 9 to look . | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
| Import Indian Rupees as a number format in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
