Change date format

[DalPai]

Good evening!


I have a column with 400 dates that are in the format "MM / DD / YYYY" and I need to convert them to "DD / MM / YYYY".


The problem is: for some reason excel reverses the month with the day in some cells.


I've

discovered something that may be related, but I can't say exactly what it means.
Selecting the column with the dates, and modifying the format for Text ... the "reversed dates" change to numbers (ex: 08/07/2018 -> 43289)

Could someone explain the reason for this? And help me with a solution.

Best Regards

 

[DalPai]

Didn't find the Edit button

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-general/1244057-change-date-format.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[Peter_SSs]

Welcome to the MrExcel board!

Select the column then use Text to Columns (on the Data ribbon tab), Delimited, move to step 3 and choose MDY in the Date drop-down, Finish