Forum Discussion

DrHoney's avatar
DrHoney
Copper Contributor
May 13, 2022
Solved

convert date format

I m struggling to convert some date (mm/dd/yyyy) into the format I want and which other data are (dd/mm/yy). I tried change the format of the whole column into what I want to but nothing changed. I t...
excel
Excel on Mac
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 13, 2022

    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.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 13, 2022

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.

Resources