title: Python 3.5 xlsxwriter assistance
body: <p>How can can I convert "Daily Return" and "MTD Return" into percentages if I am using xlsxwriter? </p>
  
  <p>*Current code being used with xlsxwriter</p>
  
  <pre><code>worksheet.write('B10', df2.loc[4,["NAV"]])
  worksheet.write('C10', df2.loc[4,["Daily_DVA"]])
  worksheet.write('D10', df2.loc[4,["MTD_DVA"]])
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/GzAfe.png" rel="nofollow noreferrer">Image 1</a></p>
  
  <p>Also how am I able to add colors to the "Trading Activity" and "Performance Data" columns along with making the text bold like the following image attached? I would also like to keep the text centered as well.</p>
  
  <p>*Current code being used with xlsxwriter</p>
  
  <pre><code>worksheet.merge_range('A2:B2', 'Trading Activity', center_format)
  worksheet.merge_range('A8:D8', 'Performance Data', center_format)
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/70u9J.png" rel="nofollow noreferrer">Image 2</a></p>