Why does Excel, drop beginning zeros in zip codes on mailing label

[Guest]

When we print mailing labels, Excel drops the beginning zero in zip codes
causing us to have to add them manually. We are working with thousands of
labels and this is very time consuming.
Thank you
Kate

 

[mrice]

If you add an apostrophe to the front of the zip code, this shouldn'
happen. It forces Excel to recognise the characters as a string instea
of a number

 

[Debra Dalgleish]

If you're printing the labels in Word, there's an article on the
Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

 

[Saruman]

Go to Format - Cells on top menu toolbar
On the Number Tab, in the left window click on Special
In the Locale dropdown, click English (United States)
You can now select Zip Code and any entry in the cell will retain formatting

 

[Guest]

If you add an apostrophe to the front of the zip code, this shouldn't
happen. It forces Excel to recognise the characters as a string instead
of a number.


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10931
View this thread: http://www.excelforum.com/showthread.php?threadid=535337

Thank you will try it

 

[Guest]

If you're printing the labels in Word, there's an article on the
Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thank you, printing again this week will try it.