Search code examples
ms-wordmailmerge

Microsoft Word Mail Merge - Percentage format when cell contains both percent and text

I am performing a mail merge and have an issue when trying to correct the percentage format. The problem is that the source column contains both a percent value and text. If I map the field, percents display as decimal in word. If I use the following, it displays correctly:

{=«Percent»*100 # 0%}

However, now when the row contains text I receive an error.

Is there another way I can do this?

Solution

  • Here is the formula you need

    {={MERGEFIELD XYZ}*100\ #0.00%}