Change the precision of calculations in a workbook - Help and How-to

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Change the precision of calculations in a workbook

Applies to: Microsoft Office Excel 2003

Caution When you change the precision of the calculations in a workbook by using the displayed (formatted) values, Excel permanently changes any constant values on the worksheets in the workbook. If you later choose to calculate with full precision, the original underlying values cannot be restored.

On the Tools menu, click Options, and then click the Calculation tab.
Under Workbook options, select the Precision as displayed check box.