my zero keeps dropping even though formatted as text

[SED]

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

 

[JP]

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

 

[FSt1]

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

 

[Gord Dibben]

When doing the Data>Text to Columns, when you get to step 3 note the "Column
Data Format"

For each column in the Wizard, check "Text"

Easiest to SHIFT + Click to select all columns.


Gord Dibben MS Excel MVP