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








Since: 8.4.04
From: New Orleans, LA

Since last post: 3294 days
Last activity: 2931 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: 9 days
Last activity: 7 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: 1 hour
Last activity: 11 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: 1227 days
Last activity: 1206 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: 3294 days
Last activity: 2931 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
(763 newer) Next thread | Previous thread
I have the 650 as well, and can't imagine using it as an mp3 player. It's huge! But I do like that my phone and palm are combined. I don't like that it doesn't have any handwriting recognition (which I loved on the Palm, but some hate it).
- Guru Zim, Palm Pilots... (2006)
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.