If you have a excel file that has the dates in the dd/mm/yyyy format and you want to convert to mm/dd/yyyy format please follow steps below.

  1. Select the Birthdate column
  2. Select the Data tab
  3. Select the Text to Columns
  4. Select Delimited
  5. Select Next
  6. From here you should be able to select date Column data format
  7. Select MDY and select next and finish