The problem you are having is that there is no such thing as the number
01234. If this is a product code or something similar, then you are
best to format the cell as text. When you tell Excel that numbers are
actually text, it will display as above (but you can't perform
calculations).

Use Format\Cells\Text

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553530