title: Excel date format mismatch
body: <p>I have a huge excel file with one column containing the date. The problem is that the date in this column is in different formats as shown below:</p>
  
  <pre><code>12/5/17 
  12/5/17 
  15-05-17 0:00
  19-05-17 0:00
  19-05-17 0:00
  22-05-17 0:00
  </code></pre>
  
  <p>Some have a time stamp in that, some are in dd/mm/yy or mm/dd/yy format. I need a single format mm/dd/yy form(no time stamp). I did try the basic methods, like formatting the cell (going to the category, choosing a single date format but for the values of m/d/yy h:mm;@ is not changing).
  I further tried using datevalue, to get the value in a new column by using the following formula: =DATEVALUE(MONTH(D2) &amp; "/" &amp; DAY(D2) &amp; "/" &amp; YEAR(D2))
  Again, it is not working. Any ideas to fix this shall be highly appreciated?
  Thanks </p>