This function has only two arguments (arguments are pieces of data the formula needs to run). Round a number to the number of digits you want by using the ROUND function. In the Decimal places box, enter the number of decimal places that you want to display. In the Category list, depending on the type of data you have, select Currency, Accounting, Percentage, or Scientific. Go to Home > Number, select the arrow next to the list of number formats, and then select More Number Formats. Go to Home > Number and select Increase Decimal or Decrease Decimal to show more or fewer digits after the decimal point.
Select the cells that you want to format.
If you want to round a number to the nearest major unit, such as thousands, hundreds, tens, or ones, use a function in a formula, follow these steps: If you don’t want unnecessary decimal places in cells because they cause # symbols to appear, or you don’t need accuracy down to the microscopic level, change the cell format to get the number of decimal places you want.
