Excel

Hello,

I have report which consist date 1-30 in that first 15 days different format. last 15 days different format. first 15 days i can change date format but i m unable to do last 15 date format not changing.
I want to do privet table using this information but due to date format different in privet table date not appear n order . so kindly advised me.
13/09/2014 16:22:53
13/09/2014 16:12:30
13/09/2014 11:40:40
13/09/2014 10:22:39
12/9/2014 21:21
12/9/2014 21:18
12/9/2014 19:13
12/9/2014 19:11
12/9/2014 19:01
12/9/2014 18:49
12/9/2014 18:45
12/9/2014 17:43
12/9/2014 17:18
12/9/2014 16:38