Either format it as 00000

or get it with

=TEXT(RIGHT(A1,5),"00000")

--
HTH

Bob Phillips

"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!!!