Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge (2003)

    I'm ready to pull my hair out over this. I have a column in my Excel spreadsheet named Daily Interest. In the field it displays the interest like so...

    0.28

    When I click on the field it displays up in the bar like so 0.27995. Then I perform a mail merge in Word, and it displays like so...
    0.27995000000000003

    I've formatted the darn field a 100 times trying to get it to carry over just as 0.28. I can't get it right. Any suggestions. It should display as 0.28 no matter where I see it.

  2. #2
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Cincinnati, Ohio, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (2003)

    Quick question:

    Does the field contain a value or is it a formula?

    If it contains a formula, try wrapping it with a ROUND() function.

    =ROUND(MyOtherFormula,2)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail Merge (2003)

    You can format the field in Word:
    - Right-click the mail merge field Daily Interest.
    - Select Toggle Field Codes from the popup menu.
    - You'll see something like this:

    { MERGEFIELD "Daily Interest" }

    - Add a formatting switch to make it look like this:

    { MERGEFIELD "Daily Interest" # "0.00" }

    - Press F9 to hide the field code and to update the field.

    PS You haven't provided feedback on the questions you asked in the Access forum recently. As a consequence, other Loungers reading those threads don't know if the replies were helpful.

Posting Permissions

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