Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/25653

From BetaArchive Wiki

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