title: accounting number format rounding percentages
body: <p>I am using the below formula to enter data into a new column and convert it to a percentage, but I cannot figure out how to get it to round more accurately. The below code always rounds the percentage to the nearest whole number. For example, 46.07% will always round to 46.00%. I get the feeling it is something simple, but everything I have tried has not worked yet...what is the solution here?</p>
  
  <pre><code>    Range("D2").FormulaR1C1 = "=(RC[2]/RC[1])-1"
      Range("D2").NumberFormat = "0.00%"
      Range("D2").Select
      Range("D2").AutoFill Destination:=Range("D2:D" &amp; lastrow)
  </code></pre>