Converting USA date to EU date doesn't work

[SaturnusDJ]

While delimiting, I chose to import the date+time as text otherwise Excel does some kind of half converting.

Example input 1: 9/1/2017 9:25:59 PM
Expected output: 01-09-2017 21:25:59 (or pc default)

Example input 2: 5/23/2017 7:56:17 AM
Expected output: 23-05-2017 07:56:17 (or pc default)

Therefor I format the cell as: m/d/jjjj u:mm:ss AM/PM
But it does not get recognized as date.

What am I doing wrong?

 

[Norie]

Why don't you specify the date/time format when delimiting?

 

[SaturnusDJ]

When I choose 'DMY' for the column, this is the output:

09-01-2017 21:25
09-03-2017 09:16
5/19/2017 9:51:27 PM
5/19/2017 10:21:41 PM

 

[Norie]

Why did you choose DMY when the date format is MDY?

 

[SaturnusDJ]

Sorry, a typo here. I indeed tried 'MDY.'