title: In which format variant array store values internally
body: <p>I have amount column which has format of number.
  I declare 2 dimensional array of type variant, first dimension, I store currency(ex. : GBP, USD) and in other dimension I store amount(eg.: 1234.22 or-1567.69)</p>
  
  <pre><code>myArray(1,0)=GBP
  myArray(1,1)= -1234.12
  myArray(2,0)=GBP
  myArray(2,1)= 1234.12
  </code></pre>
  
  <p>I am summing <code>myArray(1,1)</code> and <code>myArray(2,1)</code>, while summing it is considering format as General/Text instead of Number(which is my column format) and sum is non-zero whereas ideally sum should be 0.</p>
  
  <p>Please suggest, how do I handle this scenario?</p>