Why Your Mail Merge Shows 45231 Instead of a Date (and How to Fix It)
Word mail merge reads the value Excel stores, not the format you see in the cell. A date is stored as a serial number, a price as a bare number and a zip code without its leading zero, so that is what lands in the letter. Tell Word how to format each field with a switch, or turn the column into text in Excel before you merge.
By Alex MartinezPublished Nov 2026Find your symptom
Microsoft describes the cause in its own support article: merged data shows up in the format it is stored in, and the fix is to format the merge field in the Word document. Here is what that looks like for the problems people hit most.
| What you see | Why | Fix |
|---|---|---|
| 45231 where a date should be | Excel stores dates as a count of days since January 1, 1900 | { MERGEFIELD StartDate \@ "MMMM d, yyyy" } |
| 1250 instead of $1,250.00 | The currency format lives in the cell, not the value | { MERGEFIELD Amount \# "$#,##0.00" } |
| 12.4999999999 instead of 12.50 | A formula result carries more decimals than the cell shows | { MERGEFIELD Amount \# "0.00" } |
| 2134 instead of 02134 | Excel saved the zip code as a number and dropped the zero | Format the column as Text in Excel and re-enter the values |
| 0.15 instead of 15% | Percentages are stored as fractions | Add a helper column in Excel: =TEXT(C2,"0%") |
The date pattern is case-sensitive. MM is the month and mm is minutes, so "mm/dd/yyyy" prints the minutes where you wanted the month.
How to add a switch to a merge field
- Open the main document and press Alt+F9 (Option+F9 on a Mac) to show field codes. Each merge field turns into text like { MERGEFIELD Amount }.
- Click just before the closing brace and type the switch. Dates take \@ followed by a pattern in quotes. Numbers take \# followed by a pattern in quotes.
- Press Alt+F9 again to hide the codes, then choose Preview Results on the Mailings tab and step through a few records.
- Check a record with an empty cell and one with a large number. If those look right, the rest will.
Type the braces by pressing Ctrl+F9 if you ever build a field from scratch. Braces typed from the keyboard look the same but Word treats them as plain text.
Or fix it in Excel and leave Word alone
If several people run the same merge, editing field codes in everyone's copy of the letter gets old quickly. A helper column in the spreadsheet does the same job and survives a new letter template. Add a column next to the original, use TEXT to turn the value into exactly the characters you want printed, and map the merge field to the new column.
| Field | Helper column formula | Merges as |
|---|---|---|
| Date | =TEXT(B2,"mmmm d, yyyy") | March 3, 2027 |
| Currency | =TEXT(D2,"$#,##0.00") | $1,250.00 |
| Percent | =TEXT(C2,"0%") | 15% |
| Zip code | =TEXT(E2,"00000") | 02134 |
The trade-off is that the helper column is text. You can no longer sort or total it, so keep the original column for that.
When the formatting is a sign of a bigger problem
Dates and decimals are fixable. But if the merge is a monthly job and these keep coming up, it is worth asking what the merged documents are for. Mail merge was built for letters, envelopes and labels. It starts to strain when each document needs to be signed and returned, when you want a separate PDF per person rather than one long file, or when the people running it are not the people who built it.
Our short history of mail merge covers how that job has changed.
If the merged documents need signatures
Bulk signature sending in TurboDocx is one way to run that kind of merge. You upload a CSV or Excel file, map its columns to the variables in a template you built in Word, preview each merged document, and send the batch out for e-signature. Each person gets their own document and signing link, and you can see who has signed.
It does not make the formatting question go away completely, and it is worth knowing exactly how it behaves. Dates in an Excel file come through in your organization's date format, so they do not turn into serial numbers. Other numbers come through as plain values, the same as in Word. If you need a dollar sign, thousands separators or a leading zero, use the TEXT helper column above before you upload.
Where Word is the better tool. For printed letters, envelopes, labels and email merges from Outlook, Word mail merge already does the job and costs nothing extra. Bulk signature sending is for documents people need to sign, and it is a Pro plan feature, not part of the free plan.
Questions people ask
Why does my mail merge show a date as a number like 45231?
Excel stores every date as a serial number counted from January 1, 1900, and shows it as a date only because of the cell format. Word reads the stored value, not the format, so it prints the number. Add a date switch to the merge field, for example \@ "MMMM d, yyyy", or turn the column into text in Excel first.
How do I keep the dollar sign and two decimals in a mail merge?
Add a numeric picture switch to the merge field in Word. Press Alt+F9 to show field codes, change the field to read { MERGEFIELD Amount \# "$#,##0.00" }, then press Alt+F9 again and preview the results.
Why are the leading zeros missing from my zip codes?
Excel treats 02134 as the number 2134 unless the column is formatted as text before the data goes in. Format the column as Text, re-enter or re-import the values so the zeros are stored, and Word will merge them as they appear.
Does the TurboDocx spreadsheet upload have the same problem?
Partly. Dates in an Excel file come through in your organization date format, so they do not turn into serial numbers. Other numbers come through as plain values, so format prices and zip codes as text in the sheet if you need the dollar sign or the leading zero.
Related
Sources
- Microsoft Support: Date, Phone Number, and Currency fields are merged incorrectly when you use an Access or Excel data source in Word. Microsoft explains that merged data appears in its stored format and that the fix is a picture switch on the merge field. Checked November 2026.
- Microsoft Q&A: Mail merge date showing as number in Word. Community thread on dates merging as serial numbers.
- TurboDocx Blog: The Mail Merge Comeback. Where mail merge came from and where it is going.
- TurboDocx: Bulk signature sending guide. Spreadsheet upload, column mapping, preview and batch sending. Pro plan feature.
Try a template before you commit
The free plan includes 5 document generations and 5 signature documents a month, so you can build one template and see how your data fills it. Bulk sending is on the Pro plan.