How to round of decimals in MS Excel

In session 4rth of Intro to Microsoft Excel how the decimal digits rounds off to the nearest no. own its own?

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.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)