Use a custom number format of 000000000. Go to the Format menu,
choose Cells, then in that dialog the Number tab. There choose
Custom from the list and enter 000000000.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


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

Help