Question

How do you round to 2 decimal places in excel?

Answer 1

Select the cells that you want to format.

On the Home tab, click Increase Decimal or Decrease Decimal to show more or fewer digits after the decimal point.

On the Home tab, in the Number group, click the arrow next to the list of number formats, and then click More Number Formats.

In the Category list, depending on the type of data you have, click Currency, Accounting, Percentage, or Scientific.

In the Decimal places box, enter the number of decimal places that you want to display.

Round a number to the number of digits you want by using the ROUND function. This function has only two arguments (arguments are pieces of data the formula needs to run).

The first argument is the number you want to round, which can be a cell reference or a number.

The second argument is the number of digits you want to round the number to.