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

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...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=535337

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/as...164951033.aspx


Kate wrote:
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


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

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

--

Saruman
----------------------------------------------------------------------------
-------
All Outgoing Mail Checked By Norton Anti-Virus 2003
----------------------------------------------------------------------------
-------

"Kate" wrote in message
...
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" wrote:


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...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=535337

Thank you will try it

"Debra Dalgleish" wrote:

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/as...164951033.aspx


Kate wrote:
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


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

Thank you, printing again this week will try it.