title: Values imported from other workbook differ
body: <p>I'm writing a VBA module in Excel to populate a worksheets with data from another worksheet. It imports the data through code along these lines:</p>
  
  <pre><code>Src.Wd = Workbooks(WB_Src.Name).Sheets("Quote Product Associated View").Cells(Counter, SC_Wd).Value
  
  Workbooks(WB_Calc.Name).Worksheets(WS_CalcData.Name).Cells(Counter, 7).Value = Src.Wd
  </code></pre>
  
  <p>Everything works fine with the import, except that the numbers in many cases differ slightly from the original data. The variables defined as <code>Integer</code> are fine, unsurprisingly, but those defined as <code>Single</code> have a tendency of varying very slightly if they have a decimal. <strong>12.0</strong> will, for instance, populate fine as <strong>12.0</strong>, while <strong>16.08</strong> turns into <strong>16.079999923706</strong>.</p>
  
  <p>Any idea what the problem could be and how to remedy it? <br>
  Do I need to include a truncation, or is there a simple way of getting it across right in the first place?</p>