Microsoft KB Archive/65336

Precision as Displayed and Numbers Rounded Using Format Number PSS ID Number: Q65336 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 2.10c 2.10d 3.00 | 2.20

WINDOWS | OS/2

Summary:

The Precision As Displayed option will not work correctly if the contents of the cells used in a formula are rounded using the Format Number command.

More Information:

The Precision As Displayed option should take the displayed value and use this in any calculations made on the worksheet. However, consider the following example:

The cells in A1 and A2 are formatted using “0” and the cells in B1 and B2 are formatted using “#,”. The cells appear as follows when Precision As Displayed is activated:

The displayed values in cells B1 and B2 are ignored and the full value of the cell is used in the SUM formula.

Microsoft is researching this problem and will post new information here as it becomes available.

Copyright Microsoft Corporation 1993.