Excel file with differents format of date

Hello


In advance sorry for my english i'am french.

I am stuck on this issue since the whole night. I wish i can find the person here...

The 2 screenshot show well my problem i think.

I have different formats and I would like to have the same format.

Means; transfer the days and months between each slash to get consistency of dates are different versions (MM / DD and DD / MM) currently. How?

column A and B are the dates sometimes until the seconds or the minutes of kind of trade (about finance)

Beaucause my purpose is to rank/sort them after i will have the same format to do it.

Thanks you very much for your readings.

Caterine

I would like to know how to switch (MM / DD and DD / MM) maybe it is easy with a code using controle+h?
The list of the date are by series of dates inside so i can identify easily and change the date manualy if i could know the way?