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

[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.

 

[Mike H]

Hi,

Prefix the input with an apostrophe '

Mike

 

[Equinor]

Custom format as 00000 if you want to show 5 digits.
--
David Biddulph




Mike and David,

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!