Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jul 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I've got a little letter I wrote linked to an Excel spreadsheet to merge fields. In my "Allocation" field I have a list of numbers formatted as currency (the result of a % calculation of a budget amount). When I merge this field into the Word Document, it always shows to four decimal places, even though the source is formatted as currency. I'm able to get around that by encasing the calculation in a ROUND("amt",2) formula, but really, should that be necessary?

    Cotton

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,549
    Thanks
    3
    Thanked 149 Times in 142 Posts
    This is a common problem. Try this thread to get your currency formatting working
    http://lounge.windowssecrets.com/ind...dpost&p=380647
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,978
    Thanks
    0
    Thanked 208 Times in 189 Posts
    Hi Cotton,

    Mailmerge Number & Currency Formatting

    To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this:
    . select the field;
    . press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
    . edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
    . position the cursor anywhere in this field and press F9 to update it;
    . run your mailmerge.

    Note 1: The '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
    . \# 0 for rounded whole numbers
    . \# ,0 for rounded whole numbers with a thousands separator
    . \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
    . \# $,0 for rounded whole dollars with a thousands separator
    . \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative numbers and a hyphen for 0 values


    Mailmerge Percentage Formatting

    To control percentage formatting in Word, add a formula and numeric picture switch to the mergefield. To do this:
    . select your mergefield, which will look something like «Percent»;
    . press Ctrl-F9 to wrap another field around it, thus { «Percent» };
    . edit the field so that you get {=«Percent»*100 \# 0.00%};
    . position the cursor anywhere in this field and press F9 to update it;
    . run your mailmerge.


    Note 2: In both cases, the precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •