Microsoft KB Archive/104811
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.