To round a number with a specified number of digits, use the ROUND function. For example, we can round the 2.123456 number to 2.12 by using the ROUND function with two digits.
Copy and paste the formula into other cells after changing num_digits.
How the formula work
The formula used in our example is =ROUND(A4,2) where
number (A5) – The number that you want to round.
num_digits (3) – The number of digits to which you want the number argument.