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.

Hi,

Prefix the input with an apostrophe '

Mike


"Equinor" wrote:

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.

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

"Equinor" wrote in message
...
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" wrote:

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

"Equinor" wrote in message
...
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 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!