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.