Datetime text to Datetime Date

Hi

I am having troubles converting data in column A to datetime. I tried using datevalue function, value function, text to column to no luck. I also tried adding number to A2 (=A2+0) in hope that will convert it to number but that didnt work.
I also tried some formulas I found online but all I keep getting is #VALUE! error.

Can anyone explain what I am doing wrong please.

Thanks