title: Excel VBA rounding off automatically
body: <p>I am trying to have vba calculate certain values and display only the answers in my spreadsheet. While this is working fine for the most part, for one of my answers there is a rounding error.</p>
  
  <p>In the relevant cell instead of display 12,950.2217, it is only displaying 12,950.9200.</p>
  
  <p>This is my formula:</p>
  
  <pre><code>Sheet2.Cells(i, 19).Value = Sheet2.Cells(i, 6).Value - Sheet2.Cells(i, 18).Value
  </code></pre>
  
  <p>I imagine this might have something to do with declaring variables but for all the other formulas it is working fine.</p>
  
  <p>Thanks</p>