title: How to round to 2 decimal places in VBA?
body: <p>In cell B2 I have variable with the value 297.123 before doing calculations In VBA I would like to round this to 297.12. See the code below as to what I have tried. Both have evaluated fuel to 297. What am I doing wrong?</p>
  
  <pre><code>Dim fuel As Integer
  Dim linecount As Long
  
  linecount2 = 2
  
  fuel = Format(ws.Cells(linecount2, 2), "0.00")
  fuel = Round(ws.Cells(linecount2, 2), 2)
  </code></pre>