When you get to Step 3 of the T2C Wizard, check out the "Column Data
Format" Box. Simply click on the appropriate column(s) in the 'Data
Preview' box and click on the "Text" radio button to preserve the
column in Text format.


HTH,
JP

On Jan 8, 7:26*pm, SED wrote:
Hi need help! *I have a column of 10 digit numbers that are all different
numbers. *I need to separate the numbers into three separate columns. *Column
1 has the first three numbers, Column 2 has the next three numbers and Column
3 has the final four numbers. *Whenever I do the "text to columns" feature it
drops the zero if it is the first number in each column. *I used format as
text for all columns and it drops the zero. *I use format as number and it
drops the zero. *Don't know how to fix the problem. *

Thoughts??