Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: EXCEL Sort sequence in Foreign Lamguage

16 Feb 2011   #1

Linux CENTOS 7 / various Windows OS'es and servers
EXCEL Sort sequence in Foreign Lamguage

Hi all

Seem to have an error when trying to sort data in excel -- I've installed the IS (Icelandic) language pack both on W7 and Office 2010 --no prob but when I sort I get the standard English sequence rather than the sequence : A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Anybody else having SORT problems with EXCEL using different languages installed as a LANGUAGE PACK.

(Note EXCEL works fine if installed in the same language that the base WINDOWS install uses -for example Spanish EXCEL sorts perfectly on Spanish W7).

Same problem in Ms Office 2007 and 2010 (32 bit version) running on W7 Ultimate X-86.


My System SpecsSystem Spec
18 Feb 2011   #2

Windows 8.1 Pro RTM x64

Hi Jimbo,

Isn't the sort algorithm based on the unicode values of the characters? The standard A-Z characters have lower values than accented ones, and thus come before them when sorting alphabetically.
My System SpecsSystem Spec
18 Feb 2011   #3

Windows 7 Home Premium 64bit

Did you also set the editing language preferences in Excel Options:

Attached Thumbnails
EXCEL Sort sequence in Foreign Lamguage-excel-languages.jpg  
My System SpecsSystem Spec


 EXCEL Sort sequence in Foreign Lamguage

Thread Tools

Similar help and support threads
Thread Forum
how to sort datasheet and how to sort tables-what is the difference pl
Hi I have this assignment for school, I think I did everything except the step number 9 and 11, it seems I do something wrong or not sure about that. How to SORT THE DATASHEET in descending order and how to Sort YOUR TABLE in ascending order? Is there difference how to sort "your table" and "the...
Microsoft Office
Sort bank transaction by payee in Excel or Word 2010
I have downloaded all 2013 transactions from the bank into Excel. I want to sort the payees into itemized groups such as payments to the power company, cable television, payments for city utilities, etc. Is there a way to accomplish this in Microsoft Word 2010, Excel , or Open Office? ...
Microsoft Office
Foreign characters?
When i open my start menu and try to type in the search bar it types characters such as these фывапкуее what does this mean / how do i fix it? thank you so much.
General Discussion
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 12:12.
Twitter Facebook Google+