title: Date format issue in outlook while to excel-outlook automation
body: <p>I have exported email mesages to excel by using a macro. By using <code>Mid</code> function I have found the date in the email, but it's not formated as a date. </p>
  
  <p>For example <code>Thursday, January 12, 2012 8:30 AM</code> This date is text, not a formated date. How do I format that as a date?</p>