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.

[@TheTechTrain]

Glad it helped!

[@loganthomas6491]

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

[@TheTechTrain]

You're very welcome! So glad I could help. Good luck with your project.

[@charlesawuahsenior6333]

I love the way you teach 💯💯💯💯

[@TheTechTrain]

Thank you so much! Glad you found it helpful

[@damansarahomies]

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

[@Its303AcidBass]

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

[@MarreroFBA]

Thank you 😭😭😭

[@adalbindavis1]

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

[@anusreesudhakaransylaja8071]

Thank you!! Exactly what I needed!!

[@RAJNIKANTGUPTA7]

Thank you very much really very helpful

[@nclifeoutdoors2669]

Thanks for the video. Very helpful.

[@TheTechTrain]

Glad it was helpful!

[@udittyagi9238]

This video is very useful, really 😊

[@TheTechTrain]

Glad you think so!

[@tapasbhattacharya9590]

Helpful video. Thank you.

[@TheTechTrain]

You're welcome

[@Brumby0]

Great, to the point, awesome!

[@TheBrokenDoll6]

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.

[@rohitkurlapkar7632]

Thank you .....informative

[@TheTechTrain]

Glad you liked it.

[@luisSilva-cy7jg]

Excellent, thanks

[@TheTechTrain]

Glad you liked it!

[@emmanuelaberikae3788]

Nice one thanks

[@EdwinPenland]

This helps greatly

[@musyokamwania3743]

Perfect, Thanks

[@TheTechTrain]

Glad it helped!

[@RoosterAutoFinance]

SUPER SIR, VERY USEFUL

[@rubasalman5736]

thank you, I did not know how.

[@Sasikumar-l6z]

Can you place one detailed video: after the point value I want to highlight in the columns (Example: 26.153 means 0.153 only show the columns)

[@phyuzar5979]

Thank you so much

[@sovannetmeas]

Thanks man.

[@TheTechTrain]

Happy to help

[@siddarth2599]

THANK YOU

[@TheTechTrain]

You're welcome!

[@samj9323]

Thank you 🙏

[@TheTechTrain]

You’re welcome 😊

[@rfthreeindia7381]

Thank you helpful

[@TheTechTrain]

You're very welcome RFThree India!

[@Javed_Sharif]

Thank you for video

[@wanasaraf9124]

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.

[@gomathig8757]

Thank you!!

[@world_is_mite1508]

Thanks

[@acru518]

It really helped me with my paper. Thanks

[@TheTechTrain]

Glad to hear that

[@stephanepelletier2424]

Thanks Man :D

[@TheTechTrain]

You're very welcome!

[@DubeyjiBankner]

Thanks you

[@user-gk4wh4he5i]

Thanks Friend

[@luckyPiston]

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

[@BambiLoo]

Thank you so much!!

[@TheTechTrain]

Thank you, I'm glad it helped.

[@CCAFO]

Good

[@moriessaman2799]

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-hf4hy]

Hiw to round them but with no 2nd columb

[@dand4075]

how to delet original column.

[@oshinchanvlogs]

Thnx

[@TheTechTrain]

Welcome

[@JamesHinder]

I love excel x

[@JR537]

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

[@TheTechTrain]

=ROUND(A1)

[@ddggamerop744]

How can we change 65 into 56

[@darshanjadhav9300]

thank you

[@niteshvalecha8913]

Is there any option, If I want to use without decimal values?
Like 56.333
I want to use 56 only
Like
67.918
I want to use 67 only

[@shukla410]

you can use ROUND formula. ex round off the value of Cell A2 young use =ROUND(A2,0)

[@JamesHinder]

Woe

[@राधाकृष्ण-र9ख]

Thank you ❤

[@miroslavpavlak1319]

Thank you so much

[@TheTechTrain]

You're very welcome Miroslav Pavlák!

[@paramjit4841]

Thanks

[@sushilranmalkar8857]

Thanks