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.

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.

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.

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.

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