Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format Zip codes to print properly in a Mail merge? | Excel Discussion (Misc queries) | |||
How do I get leading zeros in zip codes in a mail merge | Excel Discussion (Misc queries) | |||
Print Formating | Excel Discussion (Misc queries) | |||
Leading zero in zip code won't print | Excel Discussion (Misc queries) | |||
Converted data to labels. The 0 in zip codes does not print | New Users to Excel |