Choose Country Driver and Sort Order

Lets you change your country driver and collating sequence.

1.	Select a country driver and sort order combination from the list box.

2.	Choose OK.

About sort order

The sort order determines the order in which 1-2-3 sorts different types of labels when you use Range Sort or Query Sort. The following table shows the three sort orders in ascending order. If you use descending order, the sequences shown here are reversed.

ASCII

Blank cells

Labels (all characters evaluated in LMBCS code order)

Values (in numerical order)

Numbers First

Blank cells

Values (in numerical order)

Labels beginning with

a space

numbers (in numerical order)

letters (in alphabetical order, lowercase letters before uppercase)

other characters (in LMBCS code order)

Numbers Last

Blank cells

Labels beginning with

a space

numbers (in numerical order)

letters (in alphabetical order, lowercase letters before uppercase)

other characters (in LMBCS code order)

Values (in numerical order)

1-2-3 ignores apostrophes and hyphens when these characters appear in entries. For example, 1-2-3 places Olden before O'Leary.

See also

Microsoft Windows documentation for information about the Windows Country setting