| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get zero to display, ie. 01234
Is there a way to display zero as a leading number, ie. 0567
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get zero to display, ie. 01234
You can use a custom format but it means you have to have a fixed sets of
digits to display 0000 as an example would return 0567 but it would also return 1234 and not 01234 -- Regards, Peo Sjoblom "coyot1" wrote in message ... Is there a way to display zero as a leading number, ie. 0567 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get zero to display, ie. 01234
Format the cell as text before you enter your data and precede the data
with an apostrophe. ex. '0543 the apostrophe will not show in the cell. Regards Cimjet "coyot1" wrote in message ... Is there a way to display zero as a leading number, ie. 0567 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
| How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
| Can I display an Excel chart as my screensaver display? | Charts and Charting in Excel | |||
| How to keep the zero on left without disappearing like 01234 | Excel Discussion (Misc queries) | |||
| How do I merge 2 cells for ex. DE (1 cell) & 01234 (2 cell) into . | Excel Discussion (Misc queries) | |||
Hybrid Mode
