title: How do I retrieve an Excel cell value in VBA as formatted in the WorkSheet?
body: <p>I need to keep leading zeros on a list of numbers. The numbers are added like this (in a loop, but this is just an example using the (1, 1):</p>
  
  <pre><code>Set cel = Sheet.worksh.Cells(1, 1)
  cel.ColumnWidth = 10
  cel.Value = e.Name
  cel.NumberFormat = "0000"
  </code></pre>
  
  <p>Where <code>e.Name</code> is the number, something like "0720". This displays on the worksheet just fine, but if I do something like this:</p>
  
  <pre><code>Msgbox Sheet.worksh.Cells(1, 1).Value
  </code></pre>
  
  <p>I get "720". I need it to be "0720", I know I could check using <code>Len()</code> and add the zeros that way, but I was wondering if there was a more direct approach with the Range object that would do this for me.</p>