You can use Word’s mail merge to insert content from a spreadsheet, table or database into your document. When you insert a percentage into Word from Excel during a mail merge, the number’s format changes. The percent symbol is removed and extra zeros are inserted. Thankfully, you can retain your value’s percentage during a mail merge, so your document appears the way you want. You can access the mail merge field codes and add switches to them during the mail merge setup. { MERGEFIELD “Percentage” # .00% } Writer Bio

How Do I Retain My Percentages From an Excel Sheet When Doing a Word Mail Merge  - 20