| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I display leading zeros?
You could enter your value as text:
Pre-format the cell as Text (format|cells|number tab in xl2003 menus), then do the data entry (including the leading 0's) or start your entry with an apostrophe: '00001234 Or you could format the cell to show what you like: Format|Cells|Number tab|Custom category 00000 (or as many 0's as you want to see) 5551scj wrote: Excel 2003 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading Zeros | Excel Worksheet Functions | |||
| Display leading zeros in numeric value without converting to text | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
| Display Binary Leading Zeros | Excel Discussion (Misc queries) | |||
| How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
