D
Dave Peterson
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:
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: