ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   printing zip codes (https://www.excelbanter.com/excel-discussion-misc-queries/104121-printing-zip-codes.html)

Farmom

printing zip codes
 
I am having trouble printing zip codes on labels. We use Excel in our address
database, I format that column for zip codes, when I merge the data into word
2003 to use in labels, it will not print the "0" when the zip codes starts
with 0. I tried to fix it word when editing the labels, then all the zip
codes start with 0. We have a database of about 4600 addresses and it is
really a pain to add the zero onto the labels of about 60-80 labels, can
anybody help me? I'm sure it is not hard to do, (well, I hope it isn't) but I
just can't figure it out. Thanks for any help.

Gary''s Student

printing zip codes
 
Format the column as Text and enter a single quote (apostrophe) before each
entry:

'08759
rather than
08759
--
Gary's Student


"Farmom" wrote:

I am having trouble printing zip codes on labels. We use Excel in our address
database, I format that column for zip codes, when I merge the data into word
2003 to use in labels, it will not print the "0" when the zip codes starts
with 0. I tried to fix it word when editing the labels, then all the zip
codes start with 0. We have a database of about 4600 addresses and it is
really a pain to add the zero onto the labels of about 60-80 labels, can
anybody help me? I'm sure it is not hard to do, (well, I hope it isn't) but I
just can't figure it out. Thanks for any help.


Farmom

printing zip codes
 
Will that be a problem for the post office? Do the machines read that? Thanks
for your repsonse!

"Gary''s Student" wrote:

Format the column as Text and enter a single quote (apostrophe) before each
entry:

'08759
rather than
08759
--
Gary's Student


"Farmom" wrote:

I am having trouble printing zip codes on labels. We use Excel in our address
database, I format that column for zip codes, when I merge the data into word
2003 to use in labels, it will not print the "0" when the zip codes starts
with 0. I tried to fix it word when editing the labels, then all the zip
codes start with 0. We have a database of about 4600 addresses and it is
really a pain to add the zero onto the labels of about 60-80 labels, can
anybody help me? I'm sure it is not hard to do, (well, I hope it isn't) but I
just can't figure it out. Thanks for any help.


Gary''s Student

printing zip codes
 
No problem. After pasting into Word, the leading zero is there, but the
leading single quote is gone.
--
Gary's Student


"Farmom" wrote:

Will that be a problem for the post office? Do the machines read that? Thanks
for your repsonse!

"Gary''s Student" wrote:

Format the column as Text and enter a single quote (apostrophe) before each
entry:

'08759
rather than
08759
--
Gary's Student


"Farmom" wrote:

I am having trouble printing zip codes on labels. We use Excel in our address
database, I format that column for zip codes, when I merge the data into word
2003 to use in labels, it will not print the "0" when the zip codes starts
with 0. I tried to fix it word when editing the labels, then all the zip
codes start with 0. We have a database of about 4600 addresses and it is
really a pain to add the zero onto the labels of about 60-80 labels, can
anybody help me? I'm sure it is not hard to do, (well, I hope it isn't) but I
just can't figure it out. Thanks for any help.


Dave Peterson

printing zip codes
 
Debra Dalgleish posted this:

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

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

Farmom wrote:

I am having trouble printing zip codes on labels. We use Excel in our address
database, I format that column for zip codes, when I merge the data into word
2003 to use in labels, it will not print the "0" when the zip codes starts
with 0. I tried to fix it word when editing the labels, then all the zip
codes start with 0. We have a database of about 4600 addresses and it is
really a pain to add the zero onto the labels of about 60-80 labels, can
anybody help me? I'm sure it is not hard to do, (well, I hope it isn't) but I
just can't figure it out. Thanks for any help.


--

Dave Peterson


All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com