Microsoft KB Archive/104811

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:13, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q104811 to Microsoft KB Archive/104811 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.