Microsoft KB Archive/57894

Works: Digits Beyond 11 Converted to Zeros in Spreadsheet

PSS ID Number: Q57894 Article last modified on 06-12-1996

1.00 1.05 2.00

MS-DOS

= SYMPTOMS =

If you enter a whole number containing more than 11 digits in a version 1.0, 1.05, or 2.0 Microsoft Works for MS-DOS Spreadsheet or Database cell, digits to the right of the eleventh digit appear as zeros.

= STATUS =

In Works 3.0 this problem does not occur; Works 3.0 changes the format to Exponential.

= MORE INFORMATION =

For example, in Works 2.0, if you format the column width as 16 and type “111111111111111” (without the quotation marks), the value appears as “111111111110000” when entered.

In the Spreadsheet or Database, formatting the cell as Fixed with 0 (zero) decimal places results in all digits displaying correctly.

Note: The screen appearance does not affect the accuracy of the result, that is, regardless of the fact that the more significant digits are displayed as zeros, calculations are performed on the true underlying value up to the 16 digit limit.

KBCategory: kbother KBSubcategory: dworkskb

Additional reference words: 1.00 2.00

=
================================================================ Copyright Microsoft Corporation 1996.