Forum Discussion
convert date format
DrHoney Select the column with the "dates" that are presumably texts. On the Data ribbon, choose Text-to-columns. Move on the step 3 (of 3) without changing anything and set the Column data format to Date and MDY to identify that the source dates are texts in the Month, Day, Year format. Press Finish. All texts that look like dates should now be real dates which you can format however you want.
DrHoney Select the column with the "dates" that are presumably texts. On the Data ribbon, choose Text-to-columns. Move on the step 3 (of 3) without changing anything and set the Column data format to Date and MDY to identify that the source dates are texts in the Month, Day, Year format. Press Finish. All texts that look like dates should now be real dates which you can format however you want.
I have a similar problem. No matter what I do I cannot format the date in DD/MM/YYYY on Mac. It looks like it doesn't understand it as date even though I select it.
