Microsoft Word Mail Merge - Percentage format when cell contains both percent and text
<p>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:</p>

<p>{=«Percent»*100 # 0%}</p>

<p>However, now when the row contains text I receive an error.</p>

<p>Is there another way I can do this?</p>