Microsoft KB Archive/51864

Works: Entering Leading Zeros in a Database

PSS ID Number: Q51864 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

To enter a zero as the first character in a string of numbers (such as in a zip code) in a Microsoft Works for MS-DOS database, enter a quotation mark (&quot;) before entering the zero. If all the numbers are entered as text (that is, with a quotation mark preceding the number), the Sort function sorts the database by number in ascending or descending order. This is because the ASCII text values of the numbers are in numeric order.

Note: If you preface a numeric string with a quotation mark, it is viewed by Works as a text string and can no longer be used in a formula.

In Works 3.0, there is an option on the Format menu called Leading Zeros. This option allows you to select how many digits you want to include in the number and then adds any leading zeros necessary to make the number that specific length.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 2.00 3.00 =

Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.