hi
when the first text to columns dialog comes up, choose fixed width.
on the second dialog, position your seperator
on the third dialog, in the upper right corner, choose text. if you leave it
at default of general, excel will strip your leading zeros and convert it
back to numbers. choosing text keeps it as text. the other groups may be
coverted to numbers unless they are mixed data.
click finish.

regards
FSt1

"DOUG" wrote:

We want to use Text to Columns to divide a field with four digits into two
columns with two digits. If one of the digits begins with zero, this does
not work - (the zero drops from the display). How do we retain the lead zero
in the resulting cell?

We have tried formatting the workbook as text prior to importing and
afterward too, to no avail. FormatNumberCustom00 did nor work either.

'Suggestions?


DOUG