How to change numbers to two decimal places on #microsoftexcel

Today I show you a very quick formatting shortcut on microsoft excel to make your numbers have 2 decimal places. #excel #exceltutorial

[bilalchoudhry]

Thank you bro it really works ... Stay blessed 😊

[Xeptha]

how did u quickly highlight all the num, beers in the collum? without the blank spaces

[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.