File Format & Compatibility

How to Fix ZIP+4 Codes Showing as 0 in Word Mail Merge

Kushani Nimanthika Sep 28, 2026 869 views

Question details

The user needs to resolve an issue where 9-digit ZIP+4 codes display as a 0 during a mail merge, while standard 5-digit ZIP codes merge correctly.

How to Fix ZIP+4 Codes Showing as 0 in Word Mail Merge

Product: Microsoft Word
Device & OS: not provided
Scenario: Performing a mail merge using a data source containing ZIP+4 postal codes (e.g., 12345-6789).
Observed behavior: The merged document outputs a 0 instead of the actual ZIP+4 value because the hyphen causes the numeric data type interpretation to fail.

Before you start

Make sure your data source (such as your Excel spreadsheet) is closed in Word before you attempt to edit its formatting.

Solution 1Recommended

Format the Data Source Column as Text

Change the format of the ZIP code column in your spreadsheet to Text so Word reads the hyphens correctly instead of treating the column as a mathematical equation.

Mail merge determines the data type of a column based on the first few rows. If it decides the column is numerical, the hyphen in a ZIP+4 code will cause a calculation error, returning a 0.

Open your data source

Open the Excel spreadsheet or data file that contains your mailing list.

Select the ZIP code column

Click the column header letter to highlight the entire column containing your ZIP codes.

Change format to Text

Right-click the highlighted column, choose 'Format Cells', navigate to the 'Number' tab, and select 'Text'. Click OK.

Re-enter data if necessary

If the cells were already entered as numbers, you may need to double-click the affected cells and press Enter to force them to refresh as text.

Save and re-merge

Save the spreadsheet, close it, and reopen your Word document to run the Mail Merge again.

Verify Data Connection: When reopening your Word document, accept the prompt to reconnect your data source to ensure the new text formatting is applied.

Solution 2

Create a Text Formula Helper Column

Use a formula in your spreadsheet to explicitly convert the ZIP+4 values into a complete text string that Word cannot misinterpret.

WPS Office Mail Merge

Perform Accurate Mail Merges with WPS Office

WPS Office provides robust Mail Merge capabilities that seamlessly integrate with your spreadsheets. It easily handles text-formatted columns, ensuring your ZIP+4 codes, leading zeros, and other special data display flawlessly.

1. Open WPS Writer: Launch WPS Writer and open your form letter or mailing label template.
2. Start Mail Merge: Navigate to the 'References' tab on the top ribbon and click the 'Mail Merge' button.
3. Connect Data Source: Click 'Open Data Source' and select your WPS Spreadsheet containing the formatted ZIP codes.
4. Insert Fields and Merge: Use 'Insert Merge Field' to place your address data, then click 'Merge to New Document' to generate your final files.

Accurately merge 9-digit ZIP codes and complex data without unexpected formatting loss.High compatibility with Microsoft Word (.docx) and Excel (.xlsx) file formats.Free, lightweight, and features a familiar interface for quick task completion.

microsoft office alternative - wps office

Frequently Asked Questions

Why do standard 5-digit ZIP codes merge fine while 9-digit codes show as 0?

Word Mail Merge determines a column's data type based on the majority of the first few rows. If it decides the column is numeric, the hyphen in a 9-digit ZIP+4 code causes a mathematical evaluation error, resulting in a 0. Standard 5-digit codes contain only numbers, so they process correctly.

Can I just remove the +4 extension from my data?

Yes. If the 4-digit routing extension is not strictly required for your mailing list, you can remove the hyphen and the last four digits in your spreadsheet. This easily bypasses the formatting issue by converting everything back to standard 5-digit numeric codes.

How can I prevent leading zeros from disappearing in Northeast US ZIP codes?

Similar to fixing the ZIP+4 issue, leading zeros drop off when Excel treats the code as a number (e.g., 01234 becomes 1234). You can fix this by formatting the entire ZIP code column as 'Text' in your spreadsheet before importing it into your mail merge.

Document & File Issues