| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format of a cell | Excel Discussion (Misc queries) | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
| Cond. Format & Absolute Cell Reference Question | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
