1
I have an Excel Spreadsheet with a ZIP code column. For some dumb reason the original spreadsheet I got had all the zip codes stored as numbers, so a ZIP code like 01234 was stored as 1234. Easy to fix with "Format Column" as "Special => ZIP Code". All values like 1234, show up as 01234. Great!
When I import it into Word via Mail Merge (to print address labels), the ZIP codes on all the addresses starting with a leading zero (like 01234) revert to their old form (1234).
How do I fix this?
The Alt F9 {MERGEFIELD "Shipping ZIP" #"00000"} works. If you have all Zip+4 codes use Alt F9 {MERGEFIELD "Shipping ZIP" #"00000-0000"} – None – 2012-10-06T20:33:43.163