title: Change text data to correct datatype
body: <p>I'm populating an Excel sheet from DTS. The result is formatted as text since DTS sees the cells as varchar(255).</p>
  
  <p>The cell-formatting is correct. The problem is that Excel is thinking of the data as text instead of datetime or numeric. </p>
  
  <p>E.g. the value in a cell shows as "2009-01-01 00:00:00". If I press F2 to edit the cell, then press ENTER, Excel realises it's a date and then formats it according to the cell formatting.</p>
  
  <p>How can I format the values as numeric or datetime with VBA?</p>