Word mail merge can ignore the date format shown in Excel and insert a value such as 1995-10-22 00:00:00 instead. The dependable fix is to add a \@ date-time picture switch to the Word MERGEFIELD. This changes how Word displays the value without changing the date stored in Excel or Access.
Change a mail-merge date format in Word
Use these steps when your merge field already exists in the document.
- Open the main Word document used for the mail merge.
- Press Alt+F9 to display field codes. A date field may look like this:
{ MERGEFIELD Date }. - Place the cursor inside the field code after the field name and add the date-time picture switch. For example:
{ MERGEFIELD Date \@ "MMMM d, yyyy" }. - Press Alt+F9 again to show field results.
- Update the field or use Mailings → Preview Results to inspect the merged value.
With a source date of July 6, 2026, the example displays July 6, 2026.
Use the exact merge-field name
The name after MERGEFIELD must match the source column or field. If the data source column is named StartDate, use:
Free tools Windows power users keep installed
One-click scans. No signup required.
#1 Best Overall
- Reliable Plug and Play: The USB receiver provides a reliable wireless connection up to 33 ft (1), so you can forget about drop-outs and delays and you can take it wherever you use your computer
- Type in Comfort: The design of this keyboard creates a comfortable typing experience thanks to the low-profile, quiet keys and standard layout with full-size F-keys, number pad, and arrow keys
- Durable and Resilient: This full-size wireless keyboard features a spill-resistant design (2), durable keys and sturdy tilt legs with adjustable height
- Long Battery Life: MK270 combo features a 36-month keyboard and 12-month mouse battery life (3), along with on/off switches allowing you to go months without the hassle of changing batteries
- Easy to Use: This wireless keyboard and mouse combo features 8 multimedia hotkeys for instant access to the Internet, email, play/pause, and volume so you can easily check out your favorite sites
{ MERGEFIELD StartDate \@ "MMMM d, yyyy" }
Do not replace the existing field with a guessed name. To see the available source names, select Mailings → Insert Merge Field. Word lists the fields from the connected Excel or Access source.
Date format switches you can use
| Field code switch | Example result for July 6, 2026 | Use when |
|---|---|---|
\@ "M/d/yyyy" |
7/6/2026 | You want a short U.S.-style date |
\@ "MM/dd/yyyy" |
07/06/2026 | You need two-digit month and day values |
\@ "d MMM yyyy" |
6 Jul 2026 | You want a compact written date |
\@ "MMM d, yyyy" |
Jul 6, 2026 | You want an abbreviated month |
\@ "MMMM d, yyyy" |
July 6, 2026 | You want a readable formal date |
\@ "dddd, MMMM d, yyyy" |
Monday, July 6, 2026 | You want the weekday included |
\@ "yyyy-MM-dd" |
2026-07-06 | You need an ISO-style date |
The symbols are case-sensitive:
M,MM,MMM, andMMMMcontrol the month.dandddcontrol the day, withddadding a leading zero.dddandddddshow abbreviated and full weekday names.yyshows a two-digit year;yyyyshows a four-digit year.- Lowercase
mrepresents minutes in a time format; uppercaseMrepresents months.
Quotation marks are required around complex date formats containing spaces or literal text. Simple formats without spaces or text, such as \@ MM/yy, can work without them; using quotes consistently for complex formats avoids errors.
Add a time to the merged date
The same \@ switch formats both dates and times. For example:
{ MERGEFIELD Appointment \@ "MMMM d, yyyy 'at' h:mm AM/PM" }
The literal word at is enclosed in single quotation marks inside the double-quoted format string. A value such as July 6, 2026 at 3:30 PM will then appear in that form.
Rank #2
- Dependable wireless connection: Enjoy the reliability and convenience of 2.4 GHz connectivity with your logitech wireless keyboard and mouse combo, wireless range up to 10 meters away at home, or work.
- Full-Size Wireless Keyboard: Comfortable, quiet typing on a familiar keyboard layout with palm rest, spill-resistant design, and media keys. This wireless keyboard and mouse logitech has easy-access to media keys
- Plug and Play: MK345 works seamlessly with Windows, macOS, and ChromeOS. Experience hassle-free setup with the logitech mk345 wireless combo and wireless keyboard mouse combo for various operating systems.
- Long-lasting Battery: The MK345 combo offers a full size keyboard battery life of up to 3 years and a mouse battery life of 18 months (1); batteries included
- Comfortable Right-handed Mouse: This wireless USB mouse with dongle works well for this wireless mouse and keyboard combo, featuring a contoured shape for all-day comfort and smooth, precise tracking and scrolling for easier navigation.
How to display one field’s code
You do not have to switch every field in the document to code view. Right-click the date field and select Toggle Field Codes. Edit the code, then right-click again and choose Toggle Field Codes to return to the result.
Alt+F9 remains useful when you want to inspect all fields in the document at once.
How to insert the date merge field first
If the date field has not been added yet:
- Put the cursor where the date should appear.
- Open the Mailings tab.
- In the Write & Insert Fields group, select Insert Merge Field.
- Choose the date column, such as
DateorAppointment. - Display the code with Alt+F9 and add the
\@switch.
The result should resemble: { MERGEFIELD Date \@ "MMMM d, yyyy" }.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Do not type the braces yourself
The braces around a Word field are special field markers. Typing braces from the keyboard creates ordinary characters, not an active field.
When manually creating a new Word field, press Ctrl+F9 to insert the field braces, then type the code between them. For an existing mail-merge field, it is safer to insert the field through Mailings → Insert Merge Field and edit its code.
Rank #3
- Durable and Reliable: This USB keyboard features a curved space bar, spill-resistant design (2), durable keys that can withstand 10 million keystrokes, and sturdy, adjustable tilt legs
- Comfortable, Familiar Typing: You’ll enjoy a comfortable and familiar typing experience thanks to the deep-profile keys and standard layout with full-size F-keys and number pad
- Full-size Sculpted Mouse: The high-definition optical USB mouse puts comfort and control in your hands with smooth, accurate tracking and an ambidextrous shape that feels good hour after hour
- Simple Set-Up: Simply plug the keyboard and mouse into the USB ports on your desktop, laptop, or netbook and you're ready to work; compatible with Windows 7, 8, 10 or later
- Clear and Convenient: The bold, bright white and long-lasting characters make the keys on this PC or laptop keyboard easy to read and extra durable
Keep or remove MERGEFORMAT
Your field may include \* MERGEFORMAT:
{ MERGEFIELD Date \@ "MMMM d, yyyy" \* MERGEFORMAT }
This switch tells Word to preserve formatting applied to the previous field result when the field updates. It is usually harmless to leave it in place. Word commonly adds it when fields are inserted through the Field dialog box.
If Word keeps restoring unwanted formatting, open the field options and clear Preserve formatting during updates, where that option is available. The date picture switch controls the displayed date pattern; \* MERGEFORMAT does not replace it.
Why changing Excel’s date format may not fix the merge
Excel stores dates as values and applies a display format to the worksheet. During a Word mail merge, particularly with an OLEDB connection to Excel or Access, Word may read the underlying value and display its native date-time representation. That is why a worksheet showing 10/22/1995 can produce 1995-10-22 00:00:00 in the merged document.
Formatting the Excel column can still make the worksheet easier to read, but it is not a reliable replacement for formatting the Word merge field. Apply the \@ switch in the main Word document.
Rank #4
- 【Ergonomic Wireless Keyboard Mouse 】: Wireless ergonomic keyboard is equipped with adjustable height tilt legs to increase comfort and prevent your wrists injury when typing for a long time. The full size wireless keyboard with numeric keypad and 12 multimedia shortcut keys, such as play/ pause, volume increase and decrease, and email, to help you improve work efficiency
- 【Stable & Reliable Wireless Connection】: This wireless keyboard and mouse combo share the same USB receiver(stored in the mouse), and they can also be used separately. Plug & play, no need to download any software, 2.4 GHz wireless provides a powerful and reliable connection up to 33 feet(10m) without any delays.You can enjoy the convenience and freedom of wireless connection at home or at work
- 【Comfortable Optical Mouse】: This compact lightweight wireless mouse features a hand-friendly contoured shape for all-day comfort, and smooth, precise tracking.1600 DPI to meet your daily needs. Perfect for home & office work and entertainment
- 【Long Battery Life】: Up to 365 Days of battery life for keyboard and mouse wireless, say goodbye to the hassle of charging cables and replacing batteries. After 10 minutes of inactivity, the wireless keyboard mouse combo will automatically go into sleep mode to save energy. The wireless keyboard requires one AAA battery, and the wireless mouse requires one AA battery.
- 【Less Noise, More Quiet Keys】: Soft membrane keys provide a quiet and comfortable typing experience, So you can type with confidence on a wireless keyboard crafted for comfort, precision and fluidity. The wireless mouse adopts silent micro-motion technology, which is almost completely silent when clicked. No more concerns about disturbing others.
Troubleshoot a date that still looks wrong
| Problem | Likely cause | Fix |
|---|---|---|
| The document shows the code instead of the date | Field-code display is enabled | Press Alt+F9, or right-click the field and select Toggle Field Codes. |
The output still includes 00:00:00 |
The \@ switch is missing or was added to ordinary text |
Confirm the active field reads, for example, { MERGEFIELD Date \@ "MM/dd/yyyy" }. |
| The field does not update | The result has not been refreshed, or the wrong document is being edited | Use Mailings → Preview Results, update the field, or complete a new merge. |
| Word reports an invalid field | Curly braces were typed manually, or quotes/switches are malformed | Insert the field through Insert Merge Field. For a manually created field, use Ctrl+F9. |
| The month and minutes are reversed or unexpected | Incorrect letter case | Use uppercase M for months and lowercase m for minutes. |
| A blank or strange date appears | The source cell is blank, text instead of a real date, or contains inconsistent values | Check the source column and confirm its values are valid dates. A display switch cannot convert arbitrary text into a date. |
Verify the completed merge
Preview several records rather than checking only the first one. Confirm records with single-digit days, two-digit days, blank values, and dates near the beginning or end of the year. If the result is correct in preview, use Mailings → Finish & Merge to create the final documents or print the merge.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
The switch affects presentation only. It does not alter the date in Excel or Access, convert the source column, or change the value used by other applications.
Microsoft’s field-formatting documentation covers Word for Microsoft 365, Word 2024, Word 2021, Word 2019, and Word 2016, including the listed Mac editions.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.FAQ
What is the correct Word mail-merge date field code?
Use the merge-field name followed by a date-time picture switch, such as { MERGEFIELD Date \@ "MMMM d, yyyy" }. Replace Date with the exact field name from your data source.
Can I change the date format only in Excel?
Not reliably. Word may use the underlying Excel or Access date-time value during an OLEDB merge. Add the \@ switch to the merge field in Word instead.
Recommended Free Tools
Best Value
- 【Lag-free & Efficient】Stable and reliable connection of wireless keyboard and mouse is up to 10m(33ft). This combo share a nano USB receiver, no need to take up additional USB ports (Also the wireless keyboard and mouse can also be used separately). Plug and play, no software needed,convenient and efficient.
- 【Quiet & Type in Comfort】Wireless keyboard come with adjustable height tilt legs to increase comfort and prevent your wrists injury when typing for a long time.Our wireless keyboard adopts a silent structure. Soft membrane keys provide a quiet and comfortable typing experience.The wireless mouse is quiet without any clicking sound also.So whether at home or in the office, you can use this combo as you please without worrying about disturbing others.
- 【Full Size Keyboard】This keyboard saves desktop space while retaining its full size.The full size wireless keyboard with numeric keypad and 12 multimedia shortcut keys, such as play/ pause, volume increase and decrease, and search, to help you improve work efficiency.
- 【Auto Power Saving Function】Wireless keyboard and mouse have a smart auto-sleep mode to save power for long battery life. They will enter sleep mode after stop using a while(Refer to the instructions for details). Unplug the receiver or after the PC shutdown, they will enter sleep mode too.You can press any keys to wake. (battery life may vary based on user and computing conditions)
- 【Comfortable Optical Mouse】This silent wireless mice provides 3 adjustable DPI (800/1200/1600) to meet your different needs in terms of sensitivity.The compact lightweight design of wireless mouse and a hand-friendly contoured shape for all-day comfort, and smooth, precise tracking. Very suitable for office and daily use.
Why does Word show a date with 00:00:00?
The source value is being displayed with its time component. Format the Word field with a switch such as \@ "MM/dd/yyyy" to suppress the time.
What does \@ mean in a MERGEFIELD?
The \@ switch specifies the displayed date or time pattern. It changes the merge result’s appearance, not the underlying source value.
Why does my date switch not work?
Check that you edited the actual field code, used the exact source-field name, used uppercase M for months, included quotation marks around complex formats, and refreshed or previewed the field afterward.
How do I show a date like July 6, 2026 at 3:30 PM?
Use { MERGEFIELD Appointment \@ "MMMM d, yyyy 'at' h:mm AM/PM" }. The single quotation marks identify at as literal text.
The Bottom Line
Format the date in Word’s merge field, not just in the spreadsheet: display the code, add a \@ switch such as \@ "MMMM d, yyyy", hide the codes, and preview or update the merge. This controls the output while leaving the original Excel or Access date unchanged.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
