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 |