How to change merge formatting for date and currency?

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 and currency. This tutorial will show you how to format date and currency properly in word during mail merge.


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 ALT + F9 to make the field coding visible.

Please add the following formatting data to «Merge_Date»: \@"dd MMMM yyyy" into the merge file of date. And the merge field of date should like this:
{MERGEFIELD Merge_Date} becomes {MERGEFIELD Merge_Date\@ "MMMM d, yyy"}

The format of date will be like this: 8/15/2015 changes to August 15, 2015


You can remove the zeros after the decimal and the merge field of currency should look like this:
{MERGEFIELD Grant_Amount \# "$,0.00;($,0.00)"} becomes {MERGEFIELD Grant_Amount \# "$,0;($,0)"}

$20,000.00 changes to $20,000

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

Was this article helpful?