Excel: Precision As Displayed Command Rounds Numbers

 Last reviewed: November 29, 1994
Article ID: Q47577
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
  • Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

SUMMARY

The Precision As Displayed command in Microsoft Excel rounds any value that has been formatted to contain a fixed number of decimal places. The values, which are stored internally, then match those showing on the screen, and all worksheet calculations use the rounded values. Values formatted as General are not effected.

Once this command has been put into effect, the original values, which may previously have contained more decimal places, are no longer available.

NOTE: This information is true only for entered values; values that are returned as a result of formulas can be returned to their full precision. In Excel 1.5 and earlier, you can restore full precision to values returned by formulas by choosing Full Precision from the Options menu. In Excel 2.0 or later, choose Calculation from the Options menu and deselect Precision As Displayed.

MORE INFORMATION

In Excel 2.0 or later, Precision As Displayed is applied only to the document for which it is chosen and the option is saved with the worksheet.

In Excel 1.5 and earlier, while the Precision As Displayed command is in force, it is applied to any worksheet that is open or activated during a session, but is not saved with the worksheet.

KBCategory: kbusage
KBSubcategory:

Additional words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.0 2.00
2.01 2.1 2.10 2.2 2.20 3.0 3.00 4.0 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.