hi
format as text AS you parse.
this can be done in the text to column wizzard on the third screen, upper
right corner.

worked for me.
regards
FSt1

"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??