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

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:

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.