title: Excel Date Format Change
body: <p>I receive a CSV file from an external data source with the dates formatted as shown below. I need to "convert" whatever is coming over into a date that can be sorted properly. I've tried text to columns, formulas, importing as text, etc but nothing will change this data into a usable format. Each date comes over in one cell. I've had to clean data in the past but the techniques used in the past are not working with this set. If anyone has any ideas I would greatly appreciate the help. Thank you.  </p>
  
  <pre><code> Apr 16 2013 12:40PM
   Apr 19 2012  3:49PM
   Apr 30 2012 10:33AM
   Aug 14 2013 10:25AM
   Aug 29 2013  4:21PM
   Dec 28 2012 10:22AM
   May 13 2013  5:02PM
  </code></pre>