Forum Discussion
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 tried other formats too but nothing.
PS the data are recognized as date and if I rewrite the date manually it converts into the format I set up.
Please bright me up
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.
