Excel date conversion

I am not sure if this is possible – I want to know if there is an easy way to convert a date entered for example 

June 16/2016 @ 1335 hrs to read 

2016-06-16@1335 hrs

 

I have about 600 rows of dates I would like to be able to sort by year then month and time 

Currently enteries are first by Text then numbers. 

 

Can you help me? 

 

By: Kelly-Ann

Leave a Reply

Your email address will not be published. Required fields are marked *