title: value of the cells are converted to numbers instead of the "000000" format
body: <p>I have a bunch of strings stored in an array in the format of "0123", but when I am trying to transfer them over into a series of the cells, the leading is lost. How to preserve the original value and format of the array? For example:</p>
  
  <pre><code>Range("B" &amp; k + 9) = abc(k)  
  </code></pre>
  
  <p>I tried <code>Range("B" &amp; k + 9).value</code>, <code>Range("B" &amp; k + 9).value2</code>, and <code>Range("B" &amp; k + 9).text</code>, all of them gave me the same thing, which is a number value without the leading <code>0</code> for example <code>123</code> and not <code>0123</code>. </p>
  
  <p>I can use the numberformat function to cosmetically show the ending value to be <code>0123</code>, but what's in the cell is still just <code>123</code>. How can I include the leading <code>0</code>?</p>