Sorting Dates with General format and time stamp

[aiki100]

Hello All -

I have been sent a worksheet with dates from a user in Australia. The date format is: 17/06/2016, so Day, Month, Year. And to be more specific, what I've been sent is: 17/06/2016 18:53, so D, M, Year and a time stamp.

There are other dates that I need to merge and sort with these. But they will not sort, and that is because (I am guessing) that I have to normalize General to Date in some manner.
I realize that I can use =LEFT( ) to strip out the time stamp, but wouldn't mind leaving it there if the actual dates themselves will sort.

I have tried a good number of things, but will not elaborate them here, as they did not work. Does anyone have any thoughts on this please?

I really appreciate it, so thank you very much!

 

[Fluff]

If you change the format of the cells to General, do you still see dates, or do you see numbers?
Also what is you standard date format?

 

[aiki100]

Hi there - Thx for the response...They are ALREADY in General format - that is the way it was delivered to me

 

[Fluff]

In that case you should be able to use Text to columns on the Data tab, to convert them to date/time.
Select the column > Text to columns > Delimited > Next > uncheck all boxes > Next > select DMY from the date dropdown > Finish.

 

[aiki100]

In that case you should be able to use Text to columns on the Data tab, to convert them to date/time.
Select the column > Text to columns > Delimited > Next > uncheck all boxes > Next > select DMY from the date dropdown > Finish.

Awesome! That indeed did the trick. Thank you very much for taking the time to answer - it is greatly appreciated...

 

[Fluff]

You're welcome & thanks for the feedback