Calculate Precision As Displayed Versus Format Number (25653)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 4.0c
- Microsoft Excel for Windows 3.0a
- Microsoft Excel for Windows 2.10d
- Microsoft Excel for Windows 2.1
- Microsoft Excel for Windows 2.01
- Microsoft Excel for Windows 2.0
- Microsoft Excel for Windows NT 5.0
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- From the Tools menu, choose Options.
- Select the Calculation tab.
- On the Calculation tab, under Workbook Options, select the Precision As
Displayed check box.
Microsoft Excel versions 4.x and earlier- From the Options menu, choose Calculation.
- 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.
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | kbualink97 KB25653 |
|---|
|