Hi Peggy,

The final screen of the TextToColumns wizard gi ves you the option of
selecting the format for each column. Select the text format option and all
should be well.

---
Regards,
Norman



"Peggy" wrote in message
...
When I try to use Text To Columns to split a long series of numbers into
several columns of numbers, if one of the numbers starts with a zero it
isn't
retained. The zero gets dropped. I tried formatting the original numbers
as
text - it didn't work.
Is there a way to split a numerical string into several columns and
retain
leading zeroe?