Fix: Excel Date and Currency Format in Word Mail Merge
If your nice Excel values turn ugly in Word Mail Merge, you are not alone. Dates become random serial numbers, money loses symbols, decimals look wrong, and formatted cells stop looking the way they should. Here is why it happens and how to get clean, professional DOCX and PDF output.
Real batch generation demo
Excel → Template → Generate → Output
Quick answer
Word Mail Merge often ignores the visible Excel formatting and reads the raw underlying value instead. That is why a date may turn into a number, a currency may lose its symbol, or decimals may look wrong in the final document.
Excel shows one thing on screen, but Word may import something more technical underneath. So what looked perfect in the spreadsheet can come out ugly in the merge result.
Common formatting problems
These are the most common complaints people hit during Word Mail Merge.
Dates turn into numbers
An Excel date like 03/07/2026 may show up in Word as a serial number instead of a readable date.
Currency symbols disappear
A properly formatted amount in Excel can lose the $, €, £, or local money format in Word.
Decimals look wrong
Values that should be 100.50 may become 100.5, 100,500000, or another ugly variation depending on locale and field behavior.
Percentages and custom formats break
Formatted cells may lose percent signs, separators, spacing, or custom display rules in the merged document.
Why Word breaks Excel formatting
Word Mail Merge is not really designed to preserve every visual format exactly as you see it in Excel.
If a cell looks like $1,250.00 in Excel, it should look the same in Word and in the final PDF.
Word pulls the raw value, applies its own field behavior, and the visible formatting is lost or changed.
That is why people get frustrated when Excel looks perfect but the merged Word document does not. The problem is not always the spreadsheet itself. The problem is how Word reads and renders merge data.
What people try first
These methods can work sometimes, but they are fragile and annoying in real workflows.
Editing merge field switches
Some users try to force date or number formats inside Word field codes, but this is tedious and easy to break.
Converting everything to text in Excel
This can help in some cases, but it creates extra cleanup work and can damage data usability in the source file.
Manual correction after merge
Fine for one document, terrible for 50, 300, or 1000 generated files.
Hope the PDF will fix it
It will not. If the Word output is wrong, the PDF output will usually stay wrong too.
The better way: generate documents using the values exactly as needed
Instead of relying on Word Mail Merge to interpret Excel fields correctly, generate the document using already prepared values that preserve the intended display format.
Dates stay readable
Keep dates in the final document the way people actually read them, not as strange internal numbers.
Money stays professional
Amounts can keep the correct symbol, separator style, and visible precision expected in business documents.
Better for bulk workflows
Generate many correct DOCX and PDF files without repairing formatting by hand.
Better for real business use
Useful for offers, invoices, reports, HR documents, legal files, product sheets, and structured PDF generation.
What clean output should look like
A professional document should preserve readable values, clean layout, and predictable results in both DOCX and PDF.
Who this is for
This issue affects more than office templates. It hits many business workflows that depend on Excel-driven documents.
Sales and quotes
Price offers and quotation files need correct currency formatting every time.
HR and contracts
Dates, salaries, and structured values must look clean and consistent in employee documents.
Finance and reporting
Reports with dates, money, and percentages cannot look broken in final DOCX or PDF exports.
Operations and admin teams
Any team generating repetitive documents from Excel benefits from predictable formatting.
Frequently asked questions
Short answers to the most common Excel-to-Word formatting questions.
Why do Excel dates lose formatting in Word Mail Merge?
Because Word often reads the raw data value instead of preserving the exact display format you see in Excel.
Why does currency formatting disappear in Word?
Word Mail Merge does not always preserve Excel cell formatting such as money symbols, separators, and decimal styling.
Can I fix this with field codes?
Sometimes partially, but it is fragile and inconvenient, especially when you need reliable output at scale.
Will the problem stay in PDF too?
Usually yes. If the Word document is generated with wrong values or formatting, the PDF export will normally keep those mistakes.
What do I get in the trial?
You can start with a 7-day trial and test unlimited DOCX and PDF generation on your own workflow.
Topics and Tags
Browse related topic clusters and workflow tags connected to this article.
Continue Reading
Explore more articles related to this workflow, problem, or document automation topic.
Fix: Word Mail Merge Not Updating Images on PDF Export
Fix Word Mail Merge cases where images look right in Word but fail, repeat, or disappear in PDF export. Learn why it happens and how to generate reliable DOCX and PDF files with correct embedded images.
Read articleFix: Word Mail Merge Showing the Same Image for Every Record
Fix the classic Word Mail Merge image bug where every record shows the same photo. Learn why it happens, what usually fails, and how to generate correct Word and PDF files with embedded images.
Read articleFix: Excel Date and Currency Format in Word Mail Merge
Learn why Excel dates and currency values often appear incorrectly in Word mail‑merge documents and follow a step‑by‑step workflow, including a ready‑made VBA helper, to guarantee proper formatting every time.
Read articleHow to Auto-Resize Images for Mail Merge in Word
Learn how to auto-resize images for Word Mail Merge without stretching, broken layouts, or manual resizing. See why standard Mail Merge struggles with photos and how to generate clean Word and PDF files at scale.
Read article