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