Mac Works: Sorting Alphanumeric Entries
PSS ID Number: Q104811 Article last modified on 10-22-1998
2.0 3.0 4.0
MACINTOSH
======================================================================
The information in this article applies to:
- == Microsoft Works for the Macintosh, versions 2.0, 3.0, and 4.0 ==
SUMMARY
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.