TigerFan55
Linguica
   
   
    
  
  
Since: 8.4.04
From: New Orleans, LA
Since last post: 2833 days
Last activity: 2470 days
| AIM: |  |
| | ICQ: |  |
| |
|  #1 Posted on 23.2.05 1541.46 | Instant Rating: 5.59 | I am trying to print mailing labels from Excel and I am having a problem with the ZIP codes. Excel won't let me start a cell with a zero, because it thinks it is a null value. Since there are many ZIP codes that start with zero, this is causing me a problem. Is there some way I can turn this off or make it so that I can start a cell with an zero? Normally, I would just type in an O (the letter O), but today when I made the labels in Word, it didn't appear. Any help with this would be greatly appreciated, I know a W will know how to do this. Thanks Much in advance. | Promote this thread! |           | JayJayDean
Scrapple
Since: 2.1.02
From: Seattle, WA
Since last post: 2 days
Last activity: 1 day
| AIM: |  |
| | | Y!: |  |
|
| #2 Posted on 23.2.05 1545.47 | Instant Rating: 7.61 | Under "Format", click "Cells...". You can change it to Text, which is the simplest thing, but under mine where it says "Number" I've got ones under "Spiecial" for ZIP and ZIP + 4. That will eliminate the autoformatting.
(edited by JayJayDean on 23.2.05 1346)
“To get ass, you’ve got to bring ass." -- Roy Jones Jr.
"Your input has been noted.
I hope you don't take it personally if I disregard it." -- Guru Zim
"Speak English or face admin retribution." -- CRZ |
| CRZ
Big Brother
Administrator
Since: 9.12.01
From: ミãƒã‚¢ãƒãƒªã‚¹
Since last post: 8 hours
Last activity: 33 min.
| #3 Posted on 23.2.05 1546.14 | Instant Rating: 8.44 | Originally posted by TigerFan55
I am trying to print mailing labels from Excel and I am having a problem with the ZIP codes. Excel won't let me start a cell with a zero, because it thinks it is a null value. Since there are many ZIP codes that start with zero, this is causing me a problem. Is there some way I can turn this off or make it so that I can start a cell with an zero? Normally, I would just type in an O (the letter O), but today when I made the labels in Word, it didn't appear. Any help with this would be greatly appreciated, I know a W will know how to do this. Thanks Much in advance.
Google: excel number format leading zeros (google.com)
When it seems like the whole world is full of idiots,
maybe your standards are a bit high. - Guru Zim |
| Merc
Potato korv
Since: 3.1.02
From: Brisbane, Australia
Since last post: 766 days
Last activity: 744 days
|  #4 Posted on 24.2.05 0050.49 | Instant Rating: 5.24 | Just put an apostrophe before the number if it starts with 0
'02345
will display as 02345 (Will say it's text, not a number, but that should be ok for zip codes). | TigerFan55
Linguica
Since: 8.4.04
From: New Orleans, LA
Since last post: 2833 days
Last activity: 2470 days
| AIM: | |
| | ICQ: | |
| |
| #5 Posted on 24.2.05 1325.23 | Instant Rating: 5.59 | | Under "Format" I went to "Cells" and then "Special" and "Zip Code." It worked perfectly. Thanks again to my fellow W's who helped, it is greatly appreciated. |
| | | | | |
