Keep the zero in a ZIP Code like 02108

Make5 minutes

The problem

Some ZIP Codes print without their first zero, so 02108 shows as 2108.

A Word address ends BOSTON MA 2108. A hand-drawn box marks it, and an arrow leads to the words first zero missing.

Why it happens

Excel can store a ZIP Code as a number, and numbers drop leading zeros. So 02108 reaches the letter as 2108.

Fix it

  1. Right-click the ZIP field and choose Toggle Field Codes. You'll see something like { MERGEFIELD ZIP5 }, with your column's name.

  2. Click right after the column name. Type a space, then this:

    \# "00000"
  3. Right-click the field and choose Update Field. If you still see the code, choose Toggle Field Codes.

  4. Click Preview Results and check a few rows.

2108 now shows as 02108, and 1 as 00001. ZIPs that already have five digits, like 10001, don't change.

Fix the ZIP in your list instead, so it stays text all the way to the letter. Try Restore a five-digit ZIP from a number or Keep number and text ZIPs as text.

A Word letter shows the ZIP5 field code with a five-digit format switch. After Toggle Field Codes, the preview shows BOSTON MA 02108.

Watch for

This is only for five-digit US ZIP Codes. A ZIP of 0 prints as 00000, which isn't a real ZIP. Fix missing ZIPs in your list first.

Tested in: Word for Windows

Microsoft's help: Format field results · Prepare your Excel list for a mail merge