How do you program Excel to round to the nearest hundreth?

Answer by  cjsmuz (162)

There are two ways: (1) format the cell to display just two decimal places (right click and select Format Cells; then select Number in the Category column; (2) Use the ROUND FUNCTION by entering the following formula in the cell(s) to be rounded: =ROUND(A1,2) -- A1 being the cell number, and 2 being two decimal places.

Answer by  PowerIsMe (844)

Lets say your data is in cell A1. In another cell, type "=round(A1, 3)" without the quotes. That tells Excel to take data from A1 and round-it-up to 3 decimal-digits.

Answer by  ralig (78)

Click on the Function, Fx, button in the formula bar. Find the ROUND function and click OK. Click on the cell that has the number to be rounded, then in the Num_digits field, put 2 and click OK.

Answer by  rajasingh (65)

1. using function round(data, num_digits) data -> Value to be rounded, num_digits-> How many digits should be rounded(for hundred two decimal places) (e.g) =round(42.63134, 2) gives result 42.63

Answer by  spaffman10000 (469)

You can change how the number displays by formatting the cell, but if you need to change the actual data, use the formula =ROUND(CELL,2) for hundredths.

Answer by  chirpynits (72)

1: Use Microsoft Excel in-built formula ROUND(number, num_digits) where number is Number which should be round up, num_digits is number of decimal digits upto which the number should be round up Option 2: Right click cell(s) and select Format Cell. Format it as a number and set the number of decimal places for the selected cell(s).

Answer by  knightmare (1231)

Right click a cell (or more) and select Format Cell. You can format it as a number and set the number of decimal places for that cell. Excel will automatically round each number to the amount of decimals you specify from then on.