In another reply I suggested custom format 000-000-0000.

If, however, you do particularly want to split the number into the different
segements, you can do that using Data/ Text to Columns, but as you don't
want to lose the leading zeroes you need to set Text as the format for each
column at the final stage of the Data/ Text to Column Wizard *before* you
exit from the wizard. If you allow it to exit setting the output as numbers
(or general), then merely formatting the cell format as text afterwards
won't recover the lost data.
--
David Biddulph

"NDF" wrote in message
...
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.