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??