title: Mailmerge - Percent in Excel Sheet converts to decmail in word document
body: <p>I have an excel sheet that contains percentages. When doing the mail merge, it brings in the percentage as a decimal. I am sure this has been asked before which is why I have researched and tried multiple methods without success.</p>
  
  <p>Currently, a field in excel that shows 60%, will display as 0.599999 in the word document:</p>
  
  <p>When I use the following it rounds the field to 1%:</p>
  
  <pre><code>{MERGEFIELD Payout2 \# ##%}
  </code></pre>
  
  <p>When I follow the steps below:</p>
  
  <ol>
  <li>select your mergefield, which will look something like «Percent»;</li>
  <li>press Ctrl-F9 to wrap another field around it, thus { «Percent» };</li>
  <li>edit the field so that you get <code>{=«Percent»*100 \# 0.00%};</code></li>
  <li>position the cursor anywhere in this field and press F9 to update it;</li>
  <li>run your mailmerge.</li>
  </ol>
  
  <p>It actuallys changes the field to 60.00% in the word document, which is strange. It should just display the mergefield statement. It's almost like it already picks up the first field from the linked excel document even though I have not ran the merge. Also, when I do actually run the merge, on the last row I get a 5852 error and the field that showed 60.00% now shows <strong>!Syntax Error, *</strong></p>
  
  <p>I have a code that automatically creates the documents as the excel sheet has multiple rows. If I leave the payout field as is and not try to adjust it to fix the format, I get no errors (Just the decimal that I don't want).</p>
  
  <p>If its not possible to convert this to a percentage that is fine, at least to a whole number. 60% to 60, so I can add the % symbol manually at the end.</p>
  
  <p>Let me know what additional information is necessary.</p>