Mailmerge number to percentage

Question

Mailmerge number to percentage

Anonymous

I have a Word merge document with a field that imports a number from a calculated cell in Excel. I've used the # option to reduce it two decimal points, but it displays as .24 when I want it to be the whole number 24 percent.

I found the instructions below that describe how to embed my current MERGEFIELD within another by using the CTRL+F9 to create outer brackets.

{={MERGEFIELD PercentagefromExcel}*100 # “## 0%” }

Remember to press Ctrl + F9 to make the field – not the curly brackets on the keyboard.

HOWEVER, when I press CTRL+F9 in Word with the field selected all it seems to do is shift the text somehow left and right. I can never get to the point where the outside bracket is inserted or anything happens that would allow me to enter this solution.

Hoping this is simple! Looking for help.....

Thanks....

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Answer 1

Suzanne S Barnhill 277.2K MVP Volunteer Moderator

It's easier to start with the outer field: { = *100 # "##0%" }. Press Ctrl+F9 to insert the brackets and type the contents between them. Then place the insertion point after the = and use the Insert Merge Field button to insert the appropriate merge field.

0 comments

Answer 2

With nothing selected, after you press Ctrl+F9 you should see a pair of braces separated by two spaces. { } That is a blank field.

What you see in the Ribbon is a result of not pressing the F9 simultaneously with the Alt Key.

A number in Excel has no formatting when it gets to Word through MailMerge.

Your number is NOT 24% but rather 0.24 to Word.

If you want it to show as 24% you need to format it in Word. Something like:

{ = { MERGEFIELD M_ARABLE } * 100 # "#0%" }

Answer 3

CTRL-F9 makes the text shift, but nothing to indicate enveloping. Here is what I have now. modified to reduce the number of decimals from around 12 or so to two.

Here is what the merged document looks like.

I want it to come over as a whole number and see instructions on how to do the embed, but I can't make it appear to do anything. Here is all it does after CTRL-F9.

Compared to the first item, the only visible change is in the word wrap on line 1 of the paragraph.

This has GOT to be simple, right? What should I expect to see after I press CTRL-F9?

All that ALT-F9 does is display those crazy blocks of capital letters in the menu bar. HELP

Answer 4

Here is a temporary link to a document with the field in it.

{ = { MERGEFIELD M_ARABLE } * 100 #"#0%" }

https://www.dropbox.com/s/dw7ugm02rgkodid/delet...

Do look at the material supplied by Doug.

Here is a link to a list of the function keys that work on fields:

http://www.addbalance.com/usersguide/fields.htm...

This link is to a page on my website. It is safe. I am providing it because I think it contains information that will help you. However, as an Independent Advisor I am required to add the following when posting here with a link to any non-Microsoft site, even my own site:

Required Notice: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Answer 5

I'm so mystifed. In Word, with nothing selected, only a blinking cursor on an empty line, all that happens when I press CTRL-F9 is that the formatting on that line changes from left to fill. That's it.

What could I possibly be doing wrong?

A bigger problem now is that this morning I was able to merge in a long text field by a) moving it to col 5, b) saving as a CSV, and c) connecting via DDE. Now that same approach fails to load all of the text field.

This is truly making me crazy.

Share via

Mailmerge number to percentage

8 answers