How do I convert birth date from international to US format in excel file?
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.
- Select the Birthdate column
- Select the Data tab
- Select the Text to Columns
- Select Delimited
- Select Next
- From here you should be able to select date Column data format
- Select MDY and select next and finish