Format cell so zeros don't dissappear?

[Neenah]

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

Help

 

[Chip Pearson]

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

 

[Anne Troy]

You need "leading zeroes" formatting, Neenah. Try these tips:
http://www.officearticles.com/excel/show_leading_zeroes_in_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Boethius1]

You have to prefix with an apostrophe, enter '000123456

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

--------------

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

Help

 

[Neenah]

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