title: How to format decimal numbers as percentage in excel using epplus?
body: <p>I'm using following code to format decimal number as percentage in excel using Epplus. I have used this <a href="https://stackoverflow.com/a/17284341/2134604">example</a>.</p>
  
  <pre><code>sheet.Cells["B:B"].Style.Numberformat.Format = "#0\\.00%";
  </code></pre>
  
  <p>The number is looking normal in sheets, but in edit bar number is looking different.</p>
  
  <p><strong>The number 9.47% is showing as 947 in edit bar.</strong></p>
  
  <p>Check the image for problem sample. How to resolve this?</p>
  
  <p><img src="https://i.stack.imgur.com/RhMIK.png" alt="enter image description here"></p>