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
jimbo45

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.

Cheers
jimbo


My System SpecsSystem Spec
.
18 Feb 2011   #2
Dwarf

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
Irene

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
.

Reply

 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
Removing Foreign MUI's etc??
hello all, i notice in my win7 installation that i have numerous folders labeled "fr-fr", "hr-hr", "it-it", "da-dk", etc. from what i gather, these are because i have a multilingual version of windows 7 (?) can anyone offer a way to safely remove them?
Customization


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 07:08.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App