How to Mail Merge in Word From an Excel File With Date Format Preserved

When you run a mail merge in Word using an Excel file, dates from your spreadsheet often appear as numbers like 45123 instead of January 15, 2024. This happens because Word reads Excel date values as serial numbers and does not automatically apply the date format you set in Excel. This article explains how to force Word to display dates in your chosen format during a mail merge.

You will learn the root cause of date formatting loss, the correct steps to prepare your Excel source file, and how to use Word field codes to lock in the exact date format. The method works in Word for Microsoft 365, Word 2021, Word 2019, and Word 2016 on Windows 10 and Windows 11.

No add-ins or third-party tools are required. The fix uses a simple change to the Excel column and a small edit in the Word mail merge field code.

Why Word Mail Merge Loses Date Formatting From Excel

Excel stores dates as serial numbers. January 1, 1900 is serial number 1, and January 15, 2024 is serial number 45276. The date format you see in the cell is a display mask applied by Excel. When Word pulls data from an Excel worksheet during a mail merge, it reads the underlying serial number, not the formatted display text. Word then applies its own default date format, which is often a number like 45276 or 01/15/2024 in a style you did not choose.

The problem is not a bug. It is a design limitation: Word does not inherit Excel cell formatting. The mail merge engine treats all data as raw values unless you explicitly tell it how to format each field. This affects dates, currency, and large numbers equally.

The Two Fix Approaches

You can fix date formatting at the source in Excel by converting the date column to text before merging. This forces Word to see the date as a text string exactly as you typed it. Alternatively, you can leave the date as a serial number in Excel and apply a format switch in the Word field code. The second method gives you more control because you can change the format later without touching the Excel file.

Both methods are covered below. Choose the one that fits your workflow.

Method 1: Format the Excel Date Column as Text Before Merging

This method changes the Excel column to Text format before you enter or paste dates. Word then reads the dates as literal text and displays them exactly as they appear in the cell.

1. Open your Excel source file
   Select the entire column that contains dates. Right-click the column header and choose Format Cells.
2. Set the format to Text
   In the Format Cells dialog, click the Number tab. Under Category, choose Text. Click OK. The column now treats all entries as text, not numbers or dates.
3. Re-enter the dates in the text-formatted column
   Type each date in the format you want to appear in Word, for example January 15, 2024 or 15-Jan-2024. Do not use a date picker or paste from a date-formatted cell. If you paste, Excel may convert the text back to a serial number.
4. Save and close the Excel file
   Word will read the dates as plain text during the merge. No field code editing is needed.
5. Run your mail merge in Word
   Open your Word document. Go to Mailings > Select Recipients > Use an Existing List. Browse to your Excel file and select the worksheet. Insert the date merge field where needed. Preview results to confirm the dates appear exactly as typed.

This method works best when you control the Excel file and can re-enter dates. If you receive a file from someone else and cannot change the column format, use Method 2.

Method 2: Apply a Date Format Switch in the Word Field Code

This method keeps the Excel date column in Date or General format and uses a Word field code switch to display the date in your chosen format. The switch overrides Word default date handling.

1. Insert the date merge field as usual
   In your Word document, place the cursor where you want the date. Go to Mailings > Insert Merge Field and select the date field. The field appears as «Date» or the name of your Excel column.
2. Reveal the field code
   Right-click the «Date» field and choose Toggle Field Codes. The field changes to something like { MERGEFIELD Date }. If you see a backslash and a format string, skip to step 4.
3. Add the date format switch
   After the field name, type a space, then \@ “MMMM d, yyyy”. The full field code looks like this: { MERGEFIELD Date \@ “MMMM d, yyyy” }. The backslash and at sign tell Word to apply a date format. The text inside the quotes defines the output. Use any combination of M (month), d (day), and y (year).
4. Right-click the field again and choose Toggle Field Codes
   The field now displays the date in the format you specified, for example January 15, 2024.
5. Complete the merge
   Go to Mailings > Finish & Merge > Edit Individual Documents. Choose All and click OK. Inspect the new document for correct date formatting on every record.

Common Date Format Switches

Replace the text inside the quotes with any of these patterns:

• “M/d/yyyy” — 1/15/2024
• “dddd, MMMM d, yyyy” — Monday, January 15, 2024
• “d-MMM-yy” — 15-Jan-24
• “MMMM yyyy” — January 2024

Letters are case-sensitive. Use M for month, d for day, and y for year. Repeat the letter to control padding and length.

Common Date Format Problems in Mail Merge

Word Shows ######## Instead of a Date

The merge field placeholder displays a row of hash symbols when the date value is missing in Excel or when the Excel cell is empty. Check the source data for blank cells. Fill in a date or remove the merge field for those records.

Date Appears as a Five-Digit Number Like 45276

This means the field code does not have the date format switch. Right-click the field, choose Toggle Field Codes, and add \@ “M/d/yyyy” or your preferred pattern. Make sure there is a space before the backslash.

Date Format Switch Does Not Work After Merging to Printer

When you merge directly to a printer, Word sends the raw serial number to the printer driver. Always merge to a new document first, verify the dates, and then print from that document.

Excel Column Contains Mixed Date and Text Entries

If some cells contain dates and others contain text like TBD, the field code switch may fail on text entries. Convert the entire column to Text format in Excel and re-enter all dates as text. Word will display both dates and text correctly.

Excel Text Column vs Word Field Code Switch

Item	Excel Text Column Method	Word Field Code Switch Method
Setup location	Excel worksheet	Word document
Requires re-entering dates	Yes — dates must be retyped as text	No — dates stay as serial numbers
Format flexibility	Fixed at time of entry	Changeable by editing the field code
Works with external Excel files	Only if you can edit the file	Yes — works with read-only files
Risk of format loss	Low — text is never converted	Medium — field code must be correct
Best for	Small lists you control	Large data sets or shared files

Choose the Excel Text Column method when you want a simple one-time setup and can edit the source file. Choose the Word Field Code Switch method when you need to keep the Excel file unchanged or want to adjust the date format without re-entering data.

You can now run a mail merge from Excel to Word and keep dates in the format you set. Before printing or emailing, merge to a new document and scan a few records to confirm the formatting is correct. For advanced control, use the \@ switch and combine it with other field switches like \ MERGEFORMAT to preserve manual edits after the merge.