In this article, you will see how to round numbers in Excel without formula. You will get to see a number of processes to round up, round down and chop off decimal numbers in Excel. Here we will mainly see the options which include the built-in features. The processes are very simple, you can choose any process that you want.
Round Numbers with Decrease and Increase Decimal option
Excel has the built-in feature under the Home tab from which you can easily round up or round down your numbers. Here in this example, we will work with the value of PI. We will round this value into different decimal places. To insert the value of PI in your worksheet. Write, =PI ()
in any cell.
As you can see this value has 14 decimal places.
Decrease Decimal Places
To decrease the decimal places, first move your cursor to Home tab and under the Number section, you will find the Decrease Decimal option. Click it after selecting your cell. You will see the decimal places are reduced. The decimal places get deducted the number of times you click on to this option.
So, to convert this value to a 5 decimal place number you have to click it 9 times as the number contains total 14 decimal places.
Increase Decimal Places
Let`s work with the number 3.14159. IF you want to increase the decimal numbers from 5 decimal places to 7 decimal places, select the number first and click on to the Increase Decimal option two times under the Home tab. You will see 2 decimal places are added to your number.
After pressing it two times you will get the below result.
Rounding Numbers with Number Format
Let`s work with the value of PI again which has 14 decimal places. Here we will round the number by selecting the decimal places specifically. To open up the Number Format, select the specific cell for which want to do the formatting. Now select the Number Format option under the Home tab.
After clicking this you will get the Format Cells Dialogue box where the Number Category is selected automatically. In this box reduce the decimal places to 5.
You can also open this box by pressing the Format Cells option after pressing the right button of your mouse to the cell.
After selecting specific decimal places press Ok, you will get to see the below result.
Using the Custom Format Option to round numbers
To open the Custom Format, click on to the Format Cells option after selecting the cell and pressing the right button of your mouse. In the Format Cells option select Custom as Category. In the type option, write 0.0000 which will make the number as 4 decimal place number. You can have a Sample in the Format Cells option from which you can see the preview. Now, after pressing OK you will see the result that you want.
Read More: Excel Custom Number Format Multiple Conditions
Chop Off Decimal Numbers in Excel
There are many ways to chop off the decimal number in Excel. Firstly, you can use the Decrease Decimal option under the Home tab which may take a bit of time. Continue to tap the Decrease Decimal button until the decimal point disappears.
Secondly, you can select the decimal place as “0” to chop off the decimal point from your number.
The third process is a complex one which uses the custom formatting. After selecting Custom in the Format Cells option type, “0” in the type section. You will see the decimal point gets disappear.
Conclusion
In this article, you get to see a number of processes on how to round numbers in Excel without formula. Here you also see the processes of chopping off the decimal point. Although many formulas can be used to perform these tasks, by using these built-in features you will find it ease while doing these tasks. Hope you will like this article. Follow us to get more useful articles.
Further Readings
- Excel Round to Nearest 100 (6 Quickest Ways)
- Excel round to nearest 10000 (5 Easiest Ways)
- How to Round up Decimals in Excel (4 Simple Ways)
- How to Round Off Numbers in Excel (4 Easy Ways)
- How to Round to Nearest Multiple of 5 in Excel (3 Easy Ways)
- Excel Round to 2 Decimal Places (with Calculator)
- Excel Number Stored As Text [4 Smart Ways]
- How to Add Leading Zeros in Excel (4 Quick Methods)
- Using Excel to Round to Nearest 1000 (7 Easy Ways)
Great!
Thanks for your feedback 🙂