Ask a new question

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.

---
Best wishes, HansV
https://www.eileenslounge.com

197 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

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

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 10, 2024 Views 149,134 Applies to: