If you split using datatext to columns you can set text format in step 3
under column data format

Regards,

Peo Sjoblom


"tom" wrote in message
...
I am splitting a cell in the cell is dix00001
I need to split it from the first three letters, and when I do I get dix
in
one cell and a 1 in the second cell and I need 00001 in the xecond cell.
I
have tried formatting the column to text and general.
Help!!!