Precision as Displayed - VERY IMPORTANT
Precision as Displayed:
Checking this box will force Excel to calculate to the number of decimal places that appear as a result of your formatting, and will permanently change any numbers stored in cells.
You need to be sure you have thought through the full implications of this before using it.
Precision as Displayed slows down calculation but as engineer I personally suggest that we should have use Precision as displayed options