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 - round

The number has been rounded.

round - round

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

round autofill - round