| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display zero at the begnning of a number sequence in Excel
How do you format cells so that zero is displayed when it is at the begining
of a number sequence? Example: 031461 displays as 31461. I need the 0 at the begining of the sequence to be displayed as well, but Excel hides it automatically. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
| Calendar Control in Excel 2000 can't display date in Excel 2003? | Excel Discussion (Misc queries) | |||
| I don't want to display any controls in excel. | Excel Discussion (Misc queries) | |||
| In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Threaded Mode
