Changing date Format
HI,
I have date format “1/29/2019 7:55:02 PM“ in several thousand cells. This is format in csv file.
I would like it to automatically change it to EU format “29/01/2019 19:55:02” or only date.
Is there possibility to do this automatically. I was unable to do correct import, and I have to fix it manually..


BR,
Borut

I solved it with regex : ([0-9]+)/+([0-9]+)/+([0-9]+) ([0-9]+):+([0-9]+):+([0-9]+) \w\w
\2.\1.\3