Results 1 to 2 of 2

Thread: Mail Merge - Decimal Point Issue - data is ok in Excel not in Word

  1. #1

    Mail Merge - Decimal Point Issue - data is ok in Excel not in Word

    Register for a FREE account, and/
    or Log in to avoid these ads!


    Excel and Word version: 2007

    I have a list of numbers which display correctly in Excel - currency to 2 decimal places - though when I create the mail merge doc in Word that I need I get varying number of decimal places. How do I stop this happening - I would like to bring through the currency symbol and display to 2 dp?

    If necessary I can live without the currency symbol coming through for the time being.

    Unfortunately because they are invoices I am creating it isn't acceptable.

    I consider myself a fairly competent user of Word and Excel but finding it frustrating to resolve this one and being my first post to the forum, I'm hoping someone can help me find a solution.



  2. #2
    Seeker DSDressler's Avatar
    Join Date
    Dec 2014
    Bend, OR
    Is this still relevant seeming it's from May??? A common problem resolved by showing/toggling the field code in the Main Document and add \#$,#.00 after the field name (within the curly brackets).

Tags for this Thread

Posting Permissions

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