The W
Views: 99944783
Main | FAQ | Search: Y! / G | Calendar | Color chart | Log in for more!
@409 .beats
The W - Internet & Computers - Excel Question Register and log in to post!
Thread rated: 6.58
Pages: 1
(765 newer) Next thread | Previous thread
User
Post (5 total)
TigerFan55
Linguica








Since: 8.4.04
From: New Orleans, LA

Since last post: 3356 days
Last activity: 2992 days
AIM:  
ICQ:  
#1 Posted on | 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: 50 days
Last activity: 4 hours
AIM:  
Y!:
#2 Posted on | 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, youve 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: 11 hours
Last activity: 2 hours
AIM:  
ICQ:  
Y!:
#3 Posted on | 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
CRZ
Merc
Potato korv








Since: 3.1.02
From: Brisbane, Australia

Since last post: 1288 days
Last activity: 1267 days
#4 Posted on | 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: 3356 days
Last activity: 2992 days
AIM:  
ICQ:  
#5 Posted on | 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.
Thread rated: 6.58
Pages: 1
Thread ahead: Robots.txt?
Next thread: CD Burning Question
Previous thread: Streaming Video Question
(765 newer) Next thread | Previous thread
Local radio stations often times are given passwords that let people by tickets earlier than the general public. Go on the websites of your local radio stations that young people in Ireland listen to(here in the US it would be alternative Rock stations)....
- ShotGunShep, Ticketmaster tips (2005)
The W - Internet & Computers - Excel QuestionRegister and log in to post!

The W™ message board

ZimBoard
©2001-2014 Brothers Zim

This old hunk of junk rendered your page in 0.066 seconds.