Filter in a different language than the Excel default's language.
Hi. I reported a problem as a question in:
Basically, I have my Excel in English language and my cells are in English format as well (UK). My subscription is Norwegian. I have the dates in my spreadsheet and when I filter it, Excel shows the months in Norwegian. The date is displayed as 23/02/2019.
But, when I change the cells formatting to 23/Dec/2019, the filter works properly, displaying the month names in English.
That's what I found.