Guide: How to Set the Rounding Precision in Microsoft Excel

When you set the rounding precision in Microsoft Excel, it will automatically round off the numeric value, this allows you to save time and become hassle-free. So this is how it works.

Setting up the excels rounding precision can definitely save you a lot of time, but before you set it up, be sure that you want all values to get rounded off.

After you set it up to round numbers, it will automatically delete all the extra data in your workbook permanently.

For example, if your value is “13.7851698” the 2 digits after the decimal point will permanently delete the “51698” and leave behind “13.76”.

This feature can be turned on and off depending on your needs, which means that you can enable it in some projects and turn it off in others.

 So where can you find the “Set Precision as Displayed” Option

The First step is to navigate to the “File” menu, this is located at the top left corner.

open the file menu

Then you select “Options” button

select the options menu

Inside the options you will see the “Advanced” category, you need to click that.

select the advanced category

When you scroll through the bottom, you will see “Set Precision as Displayed”, this is found under the “When calculating this workbook” section.

enable the set precision as displayed check box

After selecting the check box, an warning will pop up that will let you know that the data in the workbook is going to lose the accuracy permanently. Then you will click the “OK” button below.

Click OK in the warning prompt

After that, you have to press the “Ok” button that is located at the lower right part in the window, and return to the “File” menu.

click OK to exit the options window

And finally, you can now set the number of digits that are to be kept, you will need to alter the numbers that are in display in the “Home” menu’s “Number” group.

Leave a Reply

Your email address will not be published. Required fields are marked *

three × 1 =

Hit “Like” to follow us and stay tuned for the latest posts