View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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