Log in
x
or
x
x
Register
x

or
0
0
0
s2smodern

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


Extra Spaces (help you quickly remove all extra space from the whole document or a selection)

doc remove extract space
Kutools for Word: Add 100 New Advanced Features to Word 2003/2007/2010/2013/2016.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu for Office: Bring Old Look of Office 2003 Back to Office 2007, 2010, 2013 and 2016.

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


arrow blue right bubble Formatting date properly during mail merge in Word

Hot
Amazing! Using Tabs in Word like Firefox, Chrome, Internet Explore 10!

Learn more Free download

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

Kutools for Word with multiple handy Word add-ins, free to try with no limitation in 45 days.Get it Now.

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

arrow blue right bubble Kutools for Word

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

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.
People in conversation:
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    everly · 20 days ago
    what if I wanted it blank if it's zero?
    • To post as a guest, your comment is unpublished.
      Sunny · 13 days ago
      Sorry that I cannot help you. I will be appreciate that you can leave a message for me if you find the solving method. Thank u.
  • To post as a guest, your comment is unpublished.
    Natalie · 7 months ago
    Can anyone help me with a code to format my date in Word to display as 1st January 2017? Atm it is formatted to 01/01/2017 but it doesn't look quite right in the main text of a letter.

    Many thanks
  • To post as a guest, your comment is unpublished.
    Michelle · 8 months ago
    I am having issues with a mail merge from excel. I need the data to be pulled to come over as a whole number however when it comes over it is is a 0 or the first number of the number represented in excel.

    Examples
    What is is Excel
    31%
    112%
    15%

    What comes over in the merge field
    0
    1
    1

    How do I get the full number to come over? When I change the toggle items to \#0 it then comes over as
    .31
    1.12
    1.5

    Can you assist?

    MB
  • To post as a guest, your comment is unpublished.
    Robin · 9 months ago
    I am wondering how you would format if the field has a zero and you want it to be blank anything greater than zero you want the dollar amount. Thanks.
  • To post as a guest, your comment is unpublished.
    Waseem · 11 months ago
    Dears,
    I have little problem in my mail merge... The display date I need it to be shown in another language like arabic. For example, the date today is "October 30, 2016", when i switch or hit the toggle field code (Alt+F9) it will shown as
    [u]{ MERGEFIELD mydate } --> 10/30/2016[/u]
    When i want to reformate it i will be like the following
    [u]{ MERGEFIELD mydate \@ "ddmmyy"} --> 30102016[/u]
    But when i want it with what i want it to be :
    [u]{ MERGEFIELD mydate \* Arabic} --> 0[/u]

    How can i make the display date look like
    ١٠/٣٠/٢٠١٦

    Thanks and regards