title: Excel VBA - Code is converting a decimal to integer when read from cell
body: <p>I have never noticed this before and I'm not sure what it causing it. I have a series of decimal values in column A:</p>
  <p><a href="https://i.stack.imgur.com/DtFsI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DtFsI.png" alt="enter image description here" /></a></p>
  <p>...and a piece of code that is supposed to read those values:</p>
  <pre><code>currentValue = ActiveWorkbook.Sheets(&quot;Values&quot;).Cells(n, 1))
  </code></pre>
  <p><code>currentValue</code> is listed as a 'Long' in the variable explorer, but when the code reaches that line it stores the values read from the Values worksheet rounded to the nearest integer. Any ideas why? It has nothing to do with the first value being '0', I checked that!</p>