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.