![]() |
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. |
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. |
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. |
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. |
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