Setting the rounding precision forces Excel to always round numeric values to a specified number of digits following the decimal, saving you from having to use the ROUND function on each formula. Here’s how it works.
Note that setting Excel’s rounding precision can save time, but be certain you want to round all values before you enable this feature. When Excel is set to round numbers, it deletes the extra data following the precision point you set, permanently affecting the accuracy of the numbers in your workbook. This means, for example, that if a value like “12.7851698” is displayed with two digits after the decimal point, then Excel will permanently delete the “51698” and leave only the “12.76” remaining.
This feature also works on a per-workbook basis, meaning you can enable it for some workbooks and not others. You must enable it for an entire workbook, though; you can’t enable it only for specific sheets within a workbook.
Where to Find the “Set Precision As Displayed” Option
Navigate to the “File” menu.
Select the “Options” menu.
In the Excel Options window that appears, click the “Advanced” category on the left.
Post a Comment Blogger Facebook
We welcome comments that add value to the discussion. We attempt to block comments that use offensive language or appear to be spam, and our editors frequently review the comments to ensure they are appropriate. As the comments are written and submitted by visitors of The Sheen Blog, they in no way represent the opinion of The Sheen Blog. Let's work together to keep the conversation civil.