| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get left side zeros to show i.e. 00045
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to get left side zeros to show i.e. 00045
You have a few choices.
To keep the entry a real number, you can give that cell (or range of cells) a custom number format. In xl2003 menus: Select the range Format|Cells|Number tab|custom category type 00000 and finish up You can also treat the entry as text. You can preformat the cell as text (also on that Number tab in the format|cells dialog, then do the data entry. Or you can start your entry with an apostrophe: '00045 tcole wrote: -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show 2 different work sheets side by side | Excel Worksheet Functions | |||
| how to make left side stay still and right side can move left to r | Excel Discussion (Misc queries) | |||
| Excel Show sheets side by side | Excel Discussion (Misc queries) | |||
| change rows from left side to right side | Excel Discussion (Misc queries) | |||
| How do I show data on side by side plots within the same graph ra. | Charts and Charting in Excel | |||
Hybrid Mode
