![]() |
formating zip codes with leading zero to print zero
I live in New England and our zip codes start with zero. When compiling a
mailing list and then merging in Word, the zeros do not print. Is there a way to get these zeros to print without having to create a formula (which I have done). Also, I know that if you start with ' and then type your number the zero will print. I usually get a mailing list that someone has compiled and then I am stuck adding the ' to get the zeros to print. There must be an easier way!!!!! |
formating zip codes with leading zero to print zero
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. above the notch nh wrote: I live in New England and our zip codes start with zero. When compiling a mailing list and then merging in Word, the zeros do not print. Is there a way to get these zeros to print without having to create a formula (which I have done). Also, I know that if you start with ' and then type your number the zero will print. I usually get a mailing list that someone has compiled and then I am stuck adding the ' to get the zeros to print. There must be an easier way!!!!! -- Dave Peterson |
All times are GMT +1. The time now is 04:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com