Question: how to change date format in excel from m/d/yyyy to mm/dd/yyyy?
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.