Excel function ROUND

The ROUND function makes it possible to round numbers to X decimal places.

Select the ROUND function.

  • In the "Number" field, enter the name of the cell to round.
  • In the "Num_digits" field, enter the number of decimal places that you would like to round to.

Click OK.


round function

The number has been rounded.

round

To round all the numbers, you can simply do an AutoFill series.

round autofill