View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I display leading zeros?

You could enter your value as text:

Pre-format the cell as Text (format|cells|number tab in xl2003 menus), then do
the data entry (including the leading 0's)

or start your entry with an apostrophe: '00001234

Or you could format the cell to show what you like:
Format|Cells|Number tab|Custom category
00000
(or as many 0's as you want to see)


5551scj wrote:

Excel 2003


--

Dave Peterson