Losing Zeros

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

I'm a neophyte Office user. I'm doing a address list in
Excel. When I enter zip codes that have a zero for the
first digit, the program automatically eliminates them.
So, a Massachusettes zip like 01982 becomes 1982. Does
anybody know how I can stop that from happening?
 
format the cells as zip code format




: I'm a neophyte Office user. I'm doing a address list in
: Excel. When I enter zip codes that have a zero for the
: first digit, the program automatically eliminates them.
: So, a Massachusettes zip like 01982 becomes 1982. Does
: anybody know how I can stop that from happening?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 is stupid dealing with zipcodes 2
losing the leading zero when merging zip+4 postal code 1
My Cell drops the Zero if it is first. 1
forcing trailing zeros on 5-digit Zip 4
How to stop Excel from automatically truncating leading zeros 2
getting the zero digit to show in a cell e.g. 0456 3
Microsoft Excel will not show a "zero" as the first digit spot. 1
Mail Merge drops 1st digit ("0") converting from Excel to Word 3

Back
Top