How to format date, currency and number during mail merge in Word?
Mail merge is a useful tool to create a set of documents that are essentially the same but where each documents contain unique elements. However, when we merge some mails, we should pay more attention to the format of date, currency and number. This tutorial will show you how to format date, currency and number properly in word during mail merge.
Formatting date properly during mail merge in Word
Formatting currency and number properly during mail merge in Word
Before we change the format of date, number and currency in mail merge, we need to apply following operations firstly.
Step 1: select the merge field you want to change. In this case, it is Date field.
Step 2: Press Shift+F9 to make the field coding visible. The field you selected should now look like this:
{MERGEFIELD DATE}, {MERGEFIELD CURRENCY} or {«Percent»}
Formatting date properly during mail merge in Word
Please add the following formatting data: \@"dd MMMM yyyy" into the merge file of date. And the merge field of date should like this:
{MERGEFIELD DATE\@ "MMMM d, yyy"}
The format of date will be like this:
Note:you can change the date format to whatever you like. Other possible formats could be: • dd/MMM/yyyy , • d/MMM/yy, • d MMMM yyyy
| Easily split a Word document into multiple documents |
| Typically, we use copy and paste to split a Word document manually, but the Split Document utility can automatically split a document based on page, Heading 1, page break, or section break. This significantly improves work efficiency. Learn more about the Split Document feature. |
 |
| Kutools for Word: Enhance your Word experience with hundreds of handy tools. Download now and see the difference! |
Formatting currency and number properly during mail merge in Word
Please add the following formatting data \# $,0.00 into the merge file of currency, and the merge field of currency should look like this:
{MERGEFIELD CURRENCY\# $,0.00}
Note:the '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
(1). \# 0 for rounded whole numbers
(2). \# ,0 for rounded whole numbers with a thousand separator
(3). \# ,0.00 for numbers accurate to two decimal places, with a thousand separator
(4). \# $,0 for rounded whole dollar with a thousand separator
(5). \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative numbers and a hyphen for 0 values
Besides, sometimes the number may be percentage, you may need to edit the field{ «Percent» } so that you get {=«Percent»*100 \# 0.00%}.
Best Office Productivity Tools
Kutools for Word - Elevate Your Word Experience with Over 100 Remarkable Features!
🤖 Kutools AI Features: Generate Content / Rewrite Text / Document Q&A / Get Quick Answers / Translate documents / Polish Document (Preserve Format)...
📘 Document Mastery: Split Pages / Merge Documents / Export Selection in Various Formats (PDF/TXT/DOC/HTML...) / Batch Convert to PDF...
✏ Contents Editing: Batch Find and Replace across Multiple Files / Resize All Pictures / Transpose Table Rows and Columns / Convert Table to Text...
🧹 Effortless Clean: Sweap away Extra Spaces / Section Breaks / Text Boxes / Hyperlinks / For more removing tools, head to the Remove group...
➕ Creative Inserts: Insert Thousand Separators / Check Boxes / Radio Buttons / QR Code / Barcode / Multiple Pictures / Discover more in the Insert group...
🔍 Precision Selections: Pinpoint Specific Pages / Tables / Shapes / Heading Paragraphs / Enhance navigation with more Select features...
⭐ Star Enhancements: Navigate to Any Location / Auto-Insert Repetitive Text / Toggle Between Document Windows / 11 Conversion Tools...
Best Office Productivity Tools
Kutools for Word - 100+ Tools for Word
- 🤖 Kutools AI Features: Generate, Rewrite, Summarize, Translate Documents / Get Quick Answers / Polish Document (Preserve Format)
- 📘 Document Mastery: Split Pages / Merge Documents / Batch Convert to PDF
- ✏ Contents Editing: Batch Find and Replace / Resize All Pictures
- 🧹 Effortless Clean: Remove Extra Spaces / Remove Section Breaks
- ➕ Creative Inserts: Insert Thousand Separators / Insert Check Boxes / Create QR Codes