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!!!!! |
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 |