How to include lead-in 0 on zip code

Max Becker 20 Reputation points
2026-10-08T21:01:00.9366667+00:00

Formatting zip codes in an excel spreadsheet. When I transfer to mail merge in Word, the initial 0 drops out of my zip code.

Microsoft 365 and Office | Excel | For home | Windows
0 comments
Answer accepted by question author
John Jefferson Doyon 89,445 Reputation points Independent Advisor
2026-10-08T21:43:46.2833333+00:00

Hi, @Max Becker

If the ZIP code starts with 0, simply formatting the Excel cell as “00000” may not be enough because Word Mail Merge can still read the underlying number and drop the leading zero.

A reliable fix is to create a new column in Excel and use this formula, assuming the ZIP code is in A2:

=TEXT(A2,"00000")

Fill the formula down the column, then use this new column as the ZIP code field in your Word Mail Merge. This converts the ZIP code to text and preserves the leading 0.

If you are working with ZIP+4 codes such as 01234-5678, let me know since the formatting will be slightly different.

Click "Add comment" to let me know.

Thanks!

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-10-08T21:01:15.5333333+00:00

    Format the ZIP code column as Text in Excel before using it in Word mail merge. That preserves leading zeros such as 00399.

    For an existing Excel file on Windows:

    1. Open the spreadsheet.
    2. Select the column that contains the ZIP codes.
    3. Go to Home.
    4. In the Number Format box, choose Text.
    5. Save the workbook.
    6. Use that workbook as the mail merge data source in Word.

    If the data is being imported from a .csv or .txt file, set the ZIP/postal code column to Text during import:

    1. In Excel, go to Data > From Text/CSV.
    2. Select the file.
    3. In the import preview, set the ZIP/postal code column to Text.
    4. Select Load or Import.

    If Word mail merge still does not keep the Excel formatting, connect Word to the workbook by using DDE:

    1. In Word, go to File > Options > Advanced.
    2. Under General, enable Confirm file format conversion on open.
    3. Start the mail merge.
    4. When selecting the Excel file, in Confirm Data Source, choose MS Excel Worksheets via DDE (*.xls).

    This causes the data in Word to appear with the same formatting as in the Excel worksheet.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.