Formatting different sizes of currency in mail merge documents RRS feed

  • Question

  • I am trying to format currency fields for a mail merge template. The problem I am running into is that I am pulling numbers that could be 12.00, 120.00, 1,200.00, 12,000.00 up to 1,000,000.00. How do I get the format right so that no matter what the number is the commas are in the correct currency position? Just using $,0.00 does not work. It allows the entire number to be merged but there are no commas. For example using that format gave me $1200000.00 instead of $1,200,000.00. And if I use 0,000,000.00 and the number is only in the thousands or hundreds of thousands it comes out like this: $0,250,000.00 or $0,001,230.00. It's a dilemma. The reports I am building are for executives so I can't have these numbers looking like this. :-( Please tell me someone knows a workaround for this?? Thanks in advance for the help.

    Friday, April 13, 2018 12:50 AM

All replies

  • Are you sure that your system is set to use comma as thousands separator?

    If I specify \# "$,0.00" as number format in a merge field, 1200000 is displayed as $1,200,000.00

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Friday, April 13, 2018 10:26 AM
  • Hi,

    Any updates on the issue? Have you checked Hans's suggestion?

    If it helped, please remember to mark it as answer to close the thread. Thanks for your understanding.

    Best Regards,
    Winnie Liang

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Thursday, May 3, 2018 2:29 AM