Microsoft KB Archive/38210

MacWorks Error: “#Precision#” Error in Database or Spreadsheet

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

1.0 2.0 3.0 4.0

MACINTOSH

=
=========================================================

= SUMMARY =

In the Microsoft Works Database module, if you enter a 19-digit (in Works 4.0) or 17-digit (in Works 1.x, 2.0, and 3.0) or greater value in a database field with a field attribute(format) of Numeric with two decimal places, a “#Precision#” error is displayed in the field. This error message also appears if you enter a number that is greater than 9.99E+16.

If the number of decimal places in the Format Field dialog box (in Works version 4.0) or the Format Set Field Attributes dialog box (in Works 1.x, 2.0, and 3.0) is set to 4 digits, the limit is 14-digits before you receive an error message.

= CORRUPT FILES ALSO CAUSE THIS PROBLEM =

This problem can occur in the Spreadsheet module if a file is damaged, even though the cells are formatted as fixed or currency. To correct this problem, save the file in SYLK file format and reopen the file.

KBCategory: kbother kberrmsg KBSubcategory: macworkskb

Additional reference words: 1.00 2.00 3.00 4.00 mwksprb mwksss macworks mwkswp ====================================================================== Keywords : kberrmsg Version : 1.0 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbprb ============================================================================= Copyright Microsoft Corporation 1998.