| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
![Cimjet[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
