If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Intermitant failure to send e-mail in Outlook 2002 | Bob J | General Discussion | 6 | June 29th, 2005 04:47 AM |
error 550 won't deliver | theMooooo | General Discussion | 3 | March 29th, 2005 12:47 PM |
*Another* OLK 2002 sendmail/SMTP problem | steviegb | General Discussion | 11 | March 23rd, 2005 12:59 AM |
join problem | Jonas | Running & Setting Up Queries | 8 | December 23rd, 2004 07:35 AM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |