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.

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