title: classic asp, excel, stop leading 0 (zero's) from being removed
body: <p>I'm populating an excel worksheet with the results of a query.  In the results set is a 'Description' field which can basically have anything in it, including numbers prefixed with leading zero's, such like 0000234.  The problem is that in writing them to a cell, the leading zero's are getting knocked off, so in the case above I end up with 234.  How do I ensure that it is treated as a text string and what ever is in the description field is simply pasted in as is?</p>
  
  <p>The line used is:</p>
  
  <pre><code> Response.Write vbTab &amp; ResultSet(8,r)
  </code></pre>
  
  <p>Thanks R.</p>