How do I keep a zero in my first number of zip code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I put in the zip code in one of my columns it automatically takes out
the zero when that is the first number in the zip code. I am trying to keep a
NJ zip-07871 and it keeps coming back as 7871
 
Right click
Format cells
On Number tab click Special
You will see Zipcode

You can also format zipcode +4
 

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

How to merge Excel address columns when some zips begin with zeros 4
How to stop Excel from automatically truncating leading zeros 2
My Cell drops the Zero if it is first. 1
ZIP codes 1
Zip Code formatting problem 3
Editing a cell in Excel spreadsheet 2
losing the leading zero when merging zip+4 postal code 1
How do I keep zeros in front of other numbers (like a zip code)? 2

Back
Top