| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zeros Not Showing
Custom format as 00000
or format as text before you type in the number, or precede the number with an apostrophe. The latter two options will leave you with text, rather than a number, so further calculations may well be affected. -- David Biddulph "jkjmwilliams" wrote in message ... How do I force numbers beginning with a zero to show? EX: 05678 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when i megre cells that begin with zeros , I lose the zeros | Excel Discussion (Misc queries) | |||
| printing without zeros showing in a cell with formulas | Excel Worksheet Functions | |||
| Leading zeros not showing | Excel Discussion (Misc queries) | |||
| leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
