Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delimited numbers
I am trying to delimited 1,240 rows of numbers which I need to separate as
phone numbers. I need the phone numbers to be written as 314-923-0417. Right now the number is written as 3149230417. My problem is when I delimite, the system will leave off the 0 thus giving me 314-923-417 after I concatenate all my phone numbers with a 0 in the parameter are missing the 0's. I have tried formating the column as text, then as special formating. So far nothing has worked. If anyone knows how to accomplish this task please please let me know. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert tab delimited files to pipe delimited? | Excel Discussion (Misc queries) | |||
Comma Delimited Numbers | Excel Discussion (Misc queries) | |||
need help on delimited | Excel Worksheet Functions | |||
Totaling the number of comma delimited numbers in a column | Excel Worksheet Functions | |||
Converting negative/positive numbers to a CSV (Comma-delimited .TX | Excel Worksheet Functions |