Mail Merge number formating

Posted on 2012-09-20
Last Modified: 2012-09-20
I am doing an MS Word mail merge. The data is coming from an Excel spread sheet.  The merge is working, but I have a formatting problem with two fields.  In Excel I have a cell with a formula that I have adjusted the format to display 3 decimal places. In Word it is showing as the true answer of many decimal points.  I need to display only 3.  The other is a currency field that looks fine in Excel, but in Word it does not show commas.
Question by:leewallin
    LVL 7

    Accepted Solution

    When Word reads a value from Excel, it read the underlying value, not the formatted value.
    To get formatted output in MailMerge, you can format the field in Word:

    In your mailmerge document, in the first label, click on the number field and press Shift+F9 to show the underlying field.
    Then add the formatting code at the end, inside the braces.
    It should look like this (formatting for an integer with three decimal places)
    { MERGEFIELD fieldname \# 0.000 }
    or like this is you want currency with commas and currency symbol:
    { MERGEFIELD fieldname \# $###,##0.00 }

    Then press Shift+F9 again, and Update the labels to propagate the new field definition to the other labels (you may need to click preview results off and on to get the display correct).

    There's more information on the number (and other) formats here:

    Author Closing Comment

    Perfect answer.  It worked

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Introduction Everyone is using a smartphone these days. Contacts, messages, applications, documents, bookmarks, pictures, videos and other stuff which you created and are present only on your device come under the umbrella called “Personal Data”.…
    Once again I push the limits of my phone.  An introduction to the Android Google Now Launcher.
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now