Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
when I type a zip code into a cell, only zeros show up. Help?
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
when I type a zip code into a cell, only zeros show up. Help?
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 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gentlearts" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
How to make a cell show totals | Excel Discussion (Misc queries) | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions |