when I type a zip code into a cell, only zeros show up. Help?

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

Guest

We have tried format, cells, zip code. When we type in a zip code then tab to
the next cell, only zeros show up in the cell.
 
I presume you do not actually get ALL zeros.

What number did you type into the cell, is it possible that you have
Lotus 1-2-3 Transitions on in Tools, options, transition and are
doing a subtraction. I guess you said you only see zeros.

Anyway the zip code formats in Format, cells, special
require you to choose 5 digit or 9 digit, seems you chose 9 digits
and entered 5. and your actual format would be 00000-0000
so a zip code of 07710 would look like 00000-7710

I would suggest that you for the column as Text and then you can include
zip codes from any county, and sort your US zip codes properly.
http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5
 
You must log in or register to reply here.

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 enter zip starting with 0 (zero) 10
Zip Code Formatting 8
Editing a cell in Excel spreadsheet 2
how do I input zip codes with a leading zero 5
Displaying zeros in cells 2
Printing Leading Zeroes in Excel 1
Keeping Leading Zeros; How Please ? 2
ZIP codes 1

Back
Top