title: Excel dates - converting different date formats into a single format
body: <p><a href="https://i.stack.imgur.com/Dh20S.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Dh20S.png" alt="enter image description here"></a></p>
  
  <p>Have a large raw data dump and I am trying to format the dates into a consistent format. </p>
  
  <p>As you can see from the screenshot, there are two main formats, one custom mm-dd-yyyy hh:mm AM/PM and mm/dd/yyyy hh:mm:ss. One is stored as general, while the other as a custom value. </p>
  
  <p>I've tried to <code>=left(A2,8)</code>, converting via <code>text()</code> and using text to columns, but can't bring the values to a consistent value. </p>