Microsoft KB Archive/25653

= Calculate Precision As Displayed Versus Format Number =

Article ID: 25653

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 4.0c
 * Microsoft Excel 3.0a
 * Microsoft Excel 2.10d
 * Microsoft Excel 2.1 Standard Edition
 * Microsoft Excel 2.01
 * Microsoft Excel 2.0 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q25653



SUMMARY
In Microsoft Excel, numbers are rounded based on their stored values rather than on their displayed values.

When you format numbers by choosing the Cells command from the Format menu (the Numbers command in versions earlier than 5.0), you alter the way the numbers are displayed; however, when you calculate numbers, the calculations are performed with the stored versions of these numbers. When you calculate formatted values, you may receive unexpected results because the displayed versions of the numbers may be slightly different than their stored values.



WORKAROUND
To calculate numbers based on their displayed values, select the Precision As Displayed option. This option truncates numbers in cells so that the stored number is the same as the displayed number.

To select the Precision As Displayed option, follow the appropriate procedure below.

Microsoft Excel versions 5.0 and later

 * 1) From the Tools menu, choose Options.
 * 2) Select the Calculation tab.
 * 3) On the Calculation tab, under Workbook Options, select the Precision As Displayed check box.

Microsoft Excel versions 4.x and earlier

 * 1) From the Options menu, choose Calculation.
 * 2) In the Calculation dialog box, select the Precision As Displayed check box.



MORE INFORMATION
The Precision As Displayed command typically is used to prevent rounding errors when working with currency.

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 3.00 4.0 4.00

Keywords: kbualink97 KB25653

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.