View Single Post
 
Old 02-18-2019, 12:53 AM
Borut2019 Borut2019 is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2019
Posts: 5
Borut2019 is on a distinguished road
Default Changing date Format

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
Reply With Quote