Problems with sorting of text in Excel 2019

Occasional Visitor

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

1 Reply

@BojanS82 

I have no 2019, tested on 365

Before:

image.png

After:

image.png

Other words it sorts correctly. I'm on English UK locale.