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 *