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

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

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

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

Why does Excel, drop beginning zeros in zip codes on mailinglabel
 

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

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

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

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

"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

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

"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.