Decimal Places How To Round Numbers In Excel

Quick tutorial which shows how to round numbers to a set number of decimal places in Excel, and how to add decimal places to whole numbers.

[prithvirajdj]

You are the guy who knows how to help.
Thanks.

[loganthomas]

Cheers Mate. I am doing a school project and I forgot everything. You are a life saver. Cheers

[ItsAcidBass]

=ROUND(E2, 2) and then copy and past values to remove the format and retain the "123" Values (V) as needed.

[damansarahomies]

thx so much for share this tips, its save my time alot

[adalbindavis]

May God bless you. It saved lot of my time.

[RAJNIKANTGUPTA]

Thank you very much really very helpful

[TheBrokenDoll]

Hello, I am trying to convert decimals to the next whole integer in order to make graphs. I am able to convert the decimals to whole numbers however on the data sheet however, the function fx box is still showing decimals when I need those to be whole numbers as well in order to copy and paste those numbers in another sheet.

[luckyPiston]

Okay and now how do we get rid of column E as we dont need that anymore ??

[wanasaraf]

Hi, I need help getting my desired decimal number after doing an average of 4 cells. The average number gives me an unwanted decimal number both in MS Excel and Google Sheet. E.g First, I want .00 to .24 as the round number (Like: The average is 112.15, which should be 112.00), Then, .24 to .75 as .50 (Like: The average is 112.34, which should be 112.50), Finally, .76 to .99 as the next rounded number (Like: The average is 112.82, which should be 113.00). It would be a great favor, if you reply me with the formula for this problem. Have a great day. Thank you.

[acru]

It really helped me with my paper. Thanks

[moriessaman]

can u help me find the exactly answer 0.98640 in excel formula

if i use manual

12/365 = 0.03288 (round off)
then 0.03288 x 30 = 0.98640

but in excel the answer is 0.98630😢😢😢

can u help me how to get 0.98640 in excel

please help me 🙏🏻

[fornow-hfhy]

Hiw to round them but with no 2nd columb

[JR]

How to round decimals into no decimal and add one number even below 0.50. For example, 120.33, round to 121.