Is it possible to show leading zeros for "number" cells?

  • Thread starter Columbus Excel User
  • Start date
C

Columbus Excel User

I am working in Excel and would like to show leading zeros in cells that have
been formated as number cells. Is this possible and how is it done?
 
B

Bob Phillips

Format with the number of digits

For instance

Format>Cells>Custom and input 000000
 
Top