Cookies help us deliver our services. By using our services, you agree to our use of cookies.
Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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»}


Easily Split one word document into multiple

Generally, we use copy and paste to split a Word document one by one, but the Split Documnet utility can split a Word document based on page, heading1, page break or section break, which will improve the work efficience .  Click for full-featured free trial in 45 days!
ad split documents by page
 
Kutools for Word: with hundreds handy Word add-ins, free to try with no limitation in 45 days.
 
 
 
 

arrow blue right bubble 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:

change-foramt-1

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


arrow blue right bubble 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}

change-foramt-2

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%}.

Tabbed browsing & editing multiple Word documents/Excel workbooks as Firefox, Chrome, Internet Explore 10!

You may be familiar to view multiple webpages in Firefox/Chrome/IE, and switch between them by clicking corresponding tabs easily. Here, Office Tab supports similar processing, which allow you to browse multiple Word documents or Excel workbooks in one Word window or Excel window, and easily switch between them by clicking their tabs.
Click for free trial of Office Tab!

Browse multiple word documents in one window as Firefox


Kutools for Word

More than 100 Advanced Functions for Word 2003, 2007, 2010, 2013, 2016 and 2019

shot-kutools-700-225-kte

More Features  |  Free Download  |  Only $39.00 for hundreds of functions

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    cam · 2 months ago
    Hi there, I have my computer region numbering formatted so numbers are x.xxx.xxx,xx however my merge field field code format which is {MERGEFIELD UnitAmount \# "$#.##0,00;-$#.##0,00" \* MERGEFORMAT} still shows the number formatting as xx,xxx.xx. If I remove the formatting, then it displays as xxxx.xxxx
    Anyone know if this is possible and the correct formatting for Danish/German numbers? I need 1,000.00 to display as 1.000,00. Thanks in advance
  • To post as a guest, your comment is unpublished.
    Jim · 4 months ago
    Trying to add 14 days to "Current Date" for FISERV letters
  • To post as a guest, your comment is unpublished.
    Osmany Díaz · 6 months ago
    Hello, I am trying to change the date format of a field in Word that is extracted from a database (Oracle), the field arrives with date format as dd-mm-yyyy, but I need to insert that date in mm- dd-yyyy Someone could help me?
  • To post as a guest, your comment is unpublished.
    Rene · 8 months ago
    I don't want my number rounded - it must display as is in the database, i.e. must be 8809010578082 not 8809010578100
  • To post as a guest, your comment is unpublished.
    Ian Oldham · 11 months ago
    when I am merging a spreadsheet into a word doc and bringing formatted currency I use \#” £,0.00;(£,0.00)” in the formula but when I do merge it brings back all the blank cells also. How can I just bring the cells with greater than 0 in the merged document