How To Round Numbers In Excel

8.9 min read|Last Updated: December 24th, 2023|Categories: excel|
table of content

There are several reasons you might encounter a number with decimal values in Excel. It might be due to some accounting procedures or any calculations you have done. But now you don’t want to see the decimal values anymore, so you need to know how to round numbers in Excel. There are different methods for doing so, which we intend to explain in this post.

What does rounding numbers in Excel mean?

Rounding numbers in Excel means changing the numbers’ format. You can either hide the decimal part of the number or round it up or down. Round up means rounding the number to an upper level. For example, if your number is 9.55, you can round it up to 10. If you round down this number, the result will be 9. There are three functions you can use to do these calculations on Excel: Round, Roundup, and Rounddown.

Round Off Decimal Values in Excel

One of the methods of rounding numbers in Excel is by changing the numbers’ decimal digits. In this method, the operation will automatically round up or round down a number based on its decimal value. If the value is close to the next number, it will be rounded up, and if it is near the previous amount, it will be rounded down. 

The round function in Excel is as follow:

  1. Select the number that has decimal digits.
  2. Go to the Home tab and find the Number group, which has a drop-down menu.
  3. Open the menu and select Number.
    Round function in Excel.
    Figure 1- Round function in Excel.
    The Number format rounds the number with 2 digits by default. But you can still increase or decrease the digits and display your preferred number. 
  4. There are two options in the Number group, one to increase the decimal places and the other to decrease the decimal places.