Excel 2016 Tips and Tricks

Excel 2016

Lesson 3 – Using Advanced Functions

Limiting the precision of numbers

NOTE Be careful when limiting the precision of numbers because you cannot undo it. You can, however, restore your original numbers if you immediately exit the worksheet without saving the changes.



P ROCEDURES

1. Select the File tab

.

2. Select Options . 3. Select the Advanced page. 4. Under the When calculating this workbook section, select the Set precision as displayed option. 5. Select . 6. Select .



S TEP - BY -S TEP Limit the precision of numbers.

If necessary, display the Invest worksheet.

OFFICEPRO, Inc.

Page 93