I have a mail merge which contains formulas and percentages in the spreadsheet. I have added switches to the Word document but I just can't fathom out how to do the same for the percentages, nothing I try is working to get the data to look like the spreadsheet - can anyone advise where I'm going wrong.



Image with Switches
Merge Fields Image 1.JPG

Result
Merge Fields Image 2.JPG

Test Docs
Test Spreadsheet.xlsx
Test Mail Merge Fields Added - Percentages.docx

See Mailmerge Percentage Formatting in the Mailmerge Tips & Tricks 'Sticky' thread: https://www.msofficeforums.com/mail-...ps-tricks.html
You should end up with a field coded as:
{=«REINVEST»*100 \# 0.00%}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Macropod, thank you for your reply - the first thing I did was try the method described in the link to your post but I still can't get the percentage figures to reflect the same as those in the spreadsheet for columns F and M, most just display as 0.00%. Is there something else I can add to the switch?

Your first table should end up with a field coded as:
{=«REINVEST»*100 \# 0.00%}
Similarly, for your second table, you should end up with a field coded as:
{=«DRP_ALLOCATION_»*100 \# 0.00%}
It works for me with the files attached to your first post.

If you don't want the calculation field code to remain in the output document, wrap the above field codes in QUOTE fields, thus:
{QUOTE{=«REINVEST»*100 \# 0.00%}}
{QUOTE{=«DRP_ALLOCATION_»*100 \# 0.00%}}

What I did notice is that completing the mailmerge causes a 'field calculation error' to be reported for every record. That is caused by the DOCPROPERTY field in the footer and has nothing to do with the above field coding.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]