Question: how to convert m/dd/yyyy to dd/mm/yyyy in excel?
Answer: 3 Answers. Select the column, go Data > Text to Columns > next > next > select the Date option and then select the DMY or MDY according to how the data is stored. That will convert all dates stored as text to real dates which you can then format and use in calculations.