Solved

Posted on 2010-01-04

I am creating Statements from an Excel worksheet in Microsoft Word using a mail merge. I have a column of percentages in Excel formated as Percentage with 2 decimal places. When I merge the field into Word, 2% shows as .02. I tried playing with the field codes and created { ={MERGEFIELD Double_Points_Rate } *100 \# "0.0%"} (and various permutations thereof) but it either persists in displaying the .02, or displays 0% or gives me a syntax error.

How do I create the field (what steps do I take) so that my percentages look like 1% or 1.5%?

How do I create the field (what steps do I take) so that my percentages look like 1% or 1.5%?

14 Comments

This is almost perfect. The only problem remaining is that a whole number (such as 2%) shows with the decimal which I want to be optional.

The output I currently have is: 1.5% or 2.%

The output I'm seeking is: 1.5% or 2%

<!--[if supportFields]><![endif]--

**************************

I've made progress on my own. I needed to select "MERGEFIELD Double_Points_Rate" and press ctrl+F9 to enclose it in an additional set of {} brackets. Now my code looks like this: {={MERGEFIELD Double_Points_Rate} *100 \# #.#% }

This is almost perfect. The only problem remaining is that a whole number (such as 2%) shows with the decimal which I want to be optional.

The output I currently have is: 1.5% or 2.%

The output I'm seeking is: 1.5% or 2%

{={ MERGEFIELD Double_Points_Rate} *100 \# 0.0;}%

Data Result

0% 0.0%

1% 1.0%

1.5% 1.5%

The rest was all fluff.

I also see that you are not a premium member, so points are more valuable to you than to us.

Don't forget to put the leading # into the format string.

I don't know what sort of member I am - I know I pay a fee for it, though.

Premium members are flagged in the question. They seem to have unlimited points to spend. I think that they pay a particular level of subscription.

By clicking you are agreeing to Experts Exchange's Terms of Use.

Title | # Comments | Views | Activity |
---|---|---|---|

Array Formula to add additional step | 1 | 21 | |

VBA double quote escaping question | 8 | 27 | |

Excel 2016 - What is this arrow pointing to a cell? | 9 | 45 | |

Excel -- increase row height through cell entry (via VBA) | 3 | 25 |

This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

Join the community of 500,000 technology professionals and ask your questions.

Connect with top rated Experts

**12** Experts available now in Live!