![]() The numeric value of cell B2 will be rounded with two decimal places.įigure 2. Insert the ROUND formula =ROUND(B2,2) in the blank cell C2 and press Enter keyboard button.We need to achieve this task in the following steps: ![]() In this case, the ROUND function will round the numbers 1-4 down and 5-9 up at the second decimal point. Suppose we have numbers with several decimal places in multiple cells in a range B2: B11 and we need to round these numbers to 2 number of digits to the right of decimal point. Rounding Multiple Cells at Once ROUND Multiple Cells With ROUND Function This article will step through how to round multiple cells at once to specified decimal places using the ROUND function while working with a large amount of dataįigure 1. The ROUND function is used to round a number to specified decimal places or the number of digits to the left or right of the decimal point. Learn How to Round Multiple Cells at Once in Excel
0 Comments
Leave a Reply. |