How do I display leading zeros?
 

Excel 2003

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