HELP: "Text-To-Columns" loses format?

  • Thread starter Thread starter Jack Slater
  • Start date Start date
J

Jack Slater

I have a column of text.

1 cell reads:

H003402302.

I want to parse the data, using Text-To-Columns with the result being:

H|0034|023|02

When I pull the trigger, the move loses the zeros and the data reads:

H|34|23|2

What am I doing wrong? The cells are formatted as text.

JDS
 
On page 3 of 3 in the Text to Columns Wizard you have to select each column
and then set Text as its format.
 
Back
Top