On Step 3 of the "Text to Columns" Wizard, make sure you set BOTH columns to
format as text. By default, only the first column is select, thus any
changes made here are only to that column.

HTH,
Elkar


"Nancy" wrote:

We have part numbers like this one "ACC0123". We are trying to seperate the
ACC and the 0123. However, when we do the text to column and fixed width, the
"0" gets dropped. Have changed the field to be text, general, number and
nothing seems to keep the "0".
Any ideas?

Thanx