Forum Discussion
BojanS82
Jan 23, 2021Copper Contributor
Problems with sorting of text in Excel 2019
Hi.
I am having the problems with sorting of text which contains š, č, ž letters (Slovenian language). My editing language is set to Slovenian (see the attached picture), but sorting from A to Z doesn't work correctly (see the yellow cells in the picture). Correct sorting is shown in the green cells.
Changing display or help language has no effect. Sorting works in Word.
Any help is greatly appreciated.
Regards
Bojan
SOLVED: Language -> Administrative language settings -> Formats -> Format was set to Slovenian
I have no 2019, tested on 365
Before:
After:
Other words it sorts correctly. I'm on English UK locale.