how to get left side zeros to show i.e. 00045
 

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