| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do you enter zip codes starting with 0 for a mail merge
I have an address list created in Excel which I'm trying to export into a
mail merge in Word. Most of my zip codes begin with a "0" and although I'm putting an apostrophe before the zero it doesn't carry over into the mail merge so I'm coming up with a 4 number zip code instead of a full zip code. I've tried setting the format as text and as special/zip code. I was been able to make it work in one worksheet a long time ago but now it doesn't work in the others - what am I missing??? Anyone willing to help? |
| 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) | |||
| Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
| MAIL MERGE PROBLEMS | Excel Discussion (Misc queries) | |||
| Mail merge to a chart | Charts and Charting in Excel | |||
Threaded Mode
