Sorting function does not work with date

[marcvanderpeet12]

Guys,

I have a problem with the attached excel file. If im filtering on column "H" and tried to sort my date from a-z the first records go well. But if you scroll down to row 423 you will see that the sorting is not accurate anymore...

Does anybody know this problem and has a solution for it?

Dear regards,

Marc

 

[pecoflyer]

Part of your dates are not real dates but text looking like dates
To solve select the entire column -Select Data ribbon - Click Text to columns then immediately click Finish. All should sort well. Veel geluk ermee !

 

[marcvanderpeet12]

Sweet, thanks!