[RESOLVED] Sort Date Canadian Format
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??
Re: Sort Date Canadian Format
NAHHHHHHHHHHH
Date have problem to be sorted because they are stored as text and not number.
God dam excel.
Problem solved...