Dates come in 2 different formats [Closed]

Report
-
Hello,



I have a csv file which imported to excel gives me dates in 2 different formats. I need to have one single format so that we can analyse the data properly.
here is a sample of how the data looks:

10/12/2016 13:08
10/08/2016 02:44
10/11/2016 09:00
13-10-2016 03:15:18
10/12/2016 08:25
10/03/2016 04:21
10/07/2016 11:39
10/09/2016 12:26
10/12/2016 11:29
13-10-2016 10:06:30
10/11/2016 12:09
10/09/2016 08:28
10/04/2016 22:51
10/05/2016 10:51
13-10-2016 14:25:06
10/02/2016 17:20
13-10-2016 11:55:38
13-10-2016 13:42:51

I have seen that date format remains same till 12th day & since 13th day the format changes.
Please help!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!