[RESOLVED] Sort Date Canadian Format

[billhuard]

I'm trying to sort some date with the auto filter.
In Canada date format are YY/MM/DD. I don't know why but Excel just give the option for YY-MM-DD. So I need to choose the Basque format to have YY/MM/DD.

Now that my date format is alright i want to sort them ascending.

But when the sort is finished. It sort it as DD/MM/YY.

Any idea why??

[billhuard]

NAHHHHHHHHHHH

Date have problem to be sorted because they are stored as text and not number.

God dam excel.

Problem solved...