Convert US Dates to Normal

Los estúpidos gringos americanos use MDY, why? WhoDaFuckKnows(tm)

So getting dates from paypal statement exports (MDY) into the rest of the world (DMY) format:

Excel: convert dates currently in US m/d/y format to UK / NZ / AU / Europe etc etc etc d/m/y:

  1. Insert a column to the right of the MDY dates column
  2. Select the column of MDY dates
  3. Under DATA, select “Text to Columns”
  4. Select Delimited – Next
  5. Untick ALL delimiters – Next
  6. Select column format “Date: MDY” – Finish
    1. Note this data format should be what the dates are currently in, not what you want them to be
  7. Select the destination column
  8. The text will now be recognised by Excel as a date and appear as right-justified in the new column
  9. Delete the original column if all is good