Microsoft KB Archive/25930

= Microsoft Knowledge Base =

File: Unexpected Value Returned by Computed Field
Last reviewed: October 26, 1994

Article ID: Q25930

Summary:

If Microsoft File does not produce the expected value in a computed field, check the format of the fields that make up the computed field. If a field is given a number format with two decimal places showing, then that field hides any significant digits past two decimal places.

The value in the computed field should be correct to the degree of accuracy of the General number format. Changing the fields that make up the computed field to the General format will show the actual values typed in and used in calculating the computed field.