Format cell so zeros don't dissappear?
 

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

Help

Format cell so zeros don't dissappear?
 

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

Format cell so zeros don't dissappear?
 

You need "leading zeroes" formatting, Neenah. Try these tips:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.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

Format cell so zeros don't dissappear?
 

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

Format cell so zeros don't dissappear?
 

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