ZIP code problem

C

Clete

I’m trying to do a mail merge in Word. The mail database is in Excel.

The ZIP codes are correct in Excel, but when merged into the Word document,
ZIP codes are not correct.

• when they have a leading zero, 08055 becomes 8055
• for Canadian addresses, the ZIP code always becomes 0. It should be
N6L-1A4, for example.

The ZIP codes are formatted as Special, ZIP code in Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top