title: Excel How to convert datetime into only date - m/d/YYYY format
body: <p>Date column has date and time in different formats.</p>
  
  <pre><code>05-09-14 21:58
  11-08-13 11:56
  08/19/2016 11:08:46
  11-08-13 11:56
  11-08-13 12:16
  05/24/2014 08:26:06
  08/24/2016 11:00:29
  12/20/2014 09:16:19
  08/25/2016 09:38:22
  08/24/2016 10:59:05
  08/25/2016 12:36:33
  08/19/2016 10:38:37
  11-08-13 14:53
  11-08-13 16:18
  11-08-13 13:38
  10-10-13 16:14
  11-08-13 12:44
  08/31/2016 17:13:57
  </code></pre>
  
  <p>I'm trying to convert these datetime into only date m/d/YYYY format.
  I tried =TEXT(cellofdate, "m/d/YYYY") but i'm still getting time for some entries.</p>