zero as first digit

  • Thread starter Thread starter Guest
  • Start date Start date
If you want a fixed number of digits:

Format/Cells/Number/Custom 00000

will display 5 places, with the first digit 0 for numbers <=9999.

If you want to always display 0, regardless of the length of the number,
one way::


Format/Cells/Number/Custom \0General

or replace "General" with some other format.
 
Back
Top