Thank you for the help.....I have been pulling my hair out...


"Chip Pearson" wrote:

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