How to round of decimals in MS Excel


3 Answer(s)


Keep the cursor on the cell. click the "Decrease decimal" (on the top toolbar) until you see no decimal. Then in future any number you enter in that cell will be rounded up.

keep the cursor on the cell. Right click and click on format cell. Left side, click on Number and you will see an option Decimal Places. So, there you can decrease or increase as per your convenience.

keep cursor on the option decrease decimal and you can reduce decimals by this option.