Microsoft KB Archive/34026

Mac Works: Entering and Sorting Numbers Beginning with a Zero

PSS ID Number: Q34026 Article last modified on 10-22-1998

1.0 1.1 2.0 3.0

MACINTOSH

=
========================================================= 1.00 1.10 2.00 3.00 MACINTOSH kbother

= SUMMARY =

In a Microsoft Works database, if numbers are entered into a field formatted as Numeric, and the first number is a 0 (zero), the zero will be omitted when it is entered into the database.

To enter and sort numeric strings that may start with a zero, such as zip codes, format the field as Text. (For Works 1.x and 2.00, choose Set Field Attributes from the Format menu. For Works 3.00, choose Format Field from the Form menu.) When sorting, 0’s will be sorted before 1’s, keeping the intended order of the zip codes.

KBCategory: kbother KBSubcategory: macworkskb

= Additional reference words: 1.00 1.10 2.00 3.00 mswksdb =

Version : 1.0 1.1 2.0 3.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.