Convert UK date-time to US date format

[paconovellino]

hello everyone! I hope you are staying safe.

I have exported a list of dates and they are shown in the UK date time and I want to change it to the US.
I have tried text to column without any luck.
The left column is sample data and the right is how I really want the information.

Any help is appreciated.

US Spanish call logs May June July.xlsx
	A
88	11/5/21 21:44
89	7/5/21 23:42
90	7/5/21 22:56
91	7/5/21 22:44
92	7/5/21 22:42
93	7/5/21 22:40
May

11/5/21 21:44	5/11/21 21:44
7/5/21 23:42	5/7/21 23:42
7/5/21 22:56	5/7/21 22:56
7/5/21 22:44	5/7/21 22:44
7/5/21 22:42	5/7/21 22:42
7/5/21 22:40	5/7/21 22:40

 

[Marc L]

Hi !​

​

If dates are not Excel dates but just text so the Text To Column feature works every time !​

​

But if data are already Excel dates so you do not need to convert it - as obviously there are dates ! - but just to amend the cells format …​

​

A tip to know if a cell is a date or a text : no left or right neither center cell formatting : data to the left = text and to the right = date …​