Microsoft KB Archive/104811

From BetaArchive Wiki

Mac Works: Sorting Alphanumeric Entries

PSS ID Number: Q104811 Article last modified on 10-22-1998

2.0 3.0 4.0



The information in this article applies to:

  • == Microsoft Works for the Macintosh, versions 2.0, 3.0, and 4.0 ==


When you sort a Microsoft Works spreadsheet containing both text and numeric values, Works will sort numeric values first, then text values; numeric values have a higher precedence.

In addition, numbers formatted as numbers will sort numerically. However, numbers formatted as text will sort alpha fashion, not numerically.

For example, if you entered the following into a spreadsheet:

A1 2 A2 12 A3 1

Depending on the way the cells are formatted, you will receive different results after sorting:

Formatted as Numeric Formatted as Text
A1 1 A1 1
A2 2 A2 12
A3 12 A3 2

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: 2.00 3.00 mac mwksss m_eXcel alpha-numeric

Version : 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.