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








Since: 8.4.04
From: New Orleans, LA

Since last post: 3333 days
Last activity: 2970 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: 27 days
Last activity: 23 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: 4 hours
Last activity: 5 min.
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: 1266 days
Last activity: 1245 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: 3333 days
Last activity: 2970 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
(764 newer) Next thread | Previous thread
As one with this very perception about all things Norton. I am slightly intrigued. 45s install sounds promising. What about, heaven forbid, uninstalling? Not usually an easy task with some previous Norton based products.
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.065 seconds.