How do I format cells to show the number 0 as first number in seri

  • Thread starter Thread starter Equinor
  • Start date Start date
E

Equinor

Subject line pretty much says it all. Is there a way to format cells to show
0's before other digits in a series of numbers without using "Text"
formatting? I am trying to input UPC's, some of which begin with 1 or 2 zeros
and I can't get the zeroes to show up unless I choose "text" formatting.

I am using Office 2007.

Thanks in advance for your help.
 
David Biddulph said:
Custom format as 00000 if you want to show 5 digits.
--
David Biddulph




Mike and David,
Click to expand...

Thanks for the help. Both approaches work. I will probably use David's
approach because I can input the info in the cell without a note appearing .

Thanks again!
 
Back
Top