Formatting a percentage in a merge field

Hello,

I am using an excel spreadsheet to merge information into a word document.  In the spreadsheet there is a percentage field.  I now know that shift_F9 gives me the merge format, but I have not had any luck figuring out the syntax for ensuring that what is showing as 14% in the spreadsheet, shows as 14% in the document, not 0.14.

Can someone help me here please.  Thanks!

Answer
Answer

Word does not have a concept of percentages.

One option is to multiply the merge field with 100 in Excel, and make the mergefield code look like this:

{ MERGEFIELD MyField \# "0%" }

A second option is to multiply with 100 in Word:

{ =100*{ MERGEFIELD MyField } \# "0%" }

Remember, use Ctrl+F9 to insert field braces { }, do not type them yourself.

A third option is to turn on "Confirm file format conversion at open" in the General section of the Advanced "tab" of File > Options.

When you connect to the Excel workbook for the mail merge, Word will prompt you how to do that.

Click Show All, then select "MS Excel worksheets via DDE".

This will start Excel, and import the Excel values complete with their formatting.

---
Kind regards, HansV
https://www.eileenslounge.com

162 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated August 7, 2020 Views 111,742 Applies to: