zip codes in Excel

  • Thread starter Thread starter Doug Tenney
  • Start date Start date
D

Doug Tenney

I am keping a database of 500 plus. I want to enter zip codes in Vermont
that start in zero or 0, but excel is dropping the zero and I get a value
with only 4 numbers. So a zip code of "01234" only shows up as 1234

How do I get the 0 to show up as the first digit, what do I need to change?

Thanks again!!

--

========================

Doug Tenney

4872 Royalton Road SW
Lancaster, Ohio 43130-9546

(e-mail address removed)

740.681.1690

fax to 740.474.6419
 
or you could just format the zip code fields to text format.
Its not like you will be doing any calculating on the areas anyways :
 
Are you aware of the fact that XL has a "Special" format already created for
zip codes, both regular and the +4 type ?

<Format> <Cells> <Number> tab,
And click on "Special" in the Category window.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am keping a database of 500 plus. I want to enter zip codes in Vermont
that start in zero or 0, but excel is dropping the zero and I get a value
with only 4 numbers. So a zip code of "01234" only shows up as 1234

How do I get the 0 to show up as the first digit, what do I need to change?

Thanks again!!

--

========================

Doug Tenney

4872 Royalton Road SW
Lancaster, Ohio 43130-9546

(e-mail address removed)

740.681.1690

fax to 740.474.6419
 
Back
Top