You have to prefix with an apostrophe, enter '000123456

However this is a real pain, does anyone know a way to format the
cell?

--------------:)


Neenah Wrote:
Everytime I enter "000123456" and tab to next cell the zeros
disappear....I
need the zeros to remain in the cell???

Help


--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=502651