title: Date/Time format in CSV file/ excel
body: <p>with date/time formats as follows:</p>
  
  <pre><code>Date/Time
  02-05-2018 07:45
  02-05-2018 07:50
  1/17/2018 2:15
  1/17/2018 2:30
  1/17/2018 2:45
  </code></pre>
  
  <blockquote>
    <p>Above "02-05-2018" is suppose to 5th of feb, but its taking 2nd of
    May.</p>
  </blockquote>
  
  <p><em>Basically the format is as below :</em></p>
  
  <p><em>02-05-2018 07:45 - dd-mm-yyyy hh:mm with actual value 43222.32292 which is a text format i beleive</em></p>
  
  <blockquote>
    <p>Now I need to all such entries to convert to normal date/time format :
    mm-dd-yyyy hh:mm</p>
  </blockquote>
  
  <p>Please let me know, tried few approaches but no luck</p>