Making date sortable via Filters

Hello All

The dates that exported from a program for some unknown reason are unsortable in excel. I've switched on the filters and noticed that I lose the ability to sort. I'm thinking the dates have been exported in a non standard format which is why excel is not being able to sort them. How and what format should I change them to make them sortable?

Thanks

Attached file

date sorting.xls

Originally Posted by alansidman

In cell D2
Type =-value(A1), reformat to the preferred date format
Copy over and down
Sort

I'm missing something here. Is the minus before value supposed to be there? Can you give an example of a preferred date format.

Thanks

Originally Posted by alansidman

Sorry about the minus sign. Fat finger syndrome. It doesn't belong. Preferred date format refers to what date format do you want. It will return a five digit number that equates to a serial date. Click on format, Date and select the format you prefer to show.

=VALUE(A2) returns #VALUE!. I cant figure where I'm doing it wrong. Please check the attachment.