Excel is an outstanding well-developed worksheet tool that has been programmed to maximize its effectiveness. However, in some cases, it can be a bit counterproductive for your case. For example, when Excel itself rounds off the numbers. In this tutorial, you will learn 5 handy ways to stop rounding in Excel.
Download Practice Workbook
You can download the following practice workbook that we have used to prepare this article.
5 Handy Ways to Stop Rounding in Excel
1. Increase Column Width to Stop Rounding in Excel
If the number is not enough to fit in a cell, Excel rounds it in the given width of the cell. By increasing the column width, we can get rid of it.
Now, just follow the steps below to increase the column width.
- Place your cursor at the border of the column index and the cursor will turn into a double-pointed arrow. Now, after double-clicking, the column will be automatically fitted with the number.
Here is the result,
2. Change Cell Format from General to Number to Stop Rounding
When General is set as a cell format, Excel only displays a particular number of digits in a cell. Any number overtaking it is displayed in the exponential format that is also known as a scientific format.
Follow the steps below to get rid of this problem.
- First, select the cell. Then, go to the Home tab. Then click on the Number group. And then, select the Number option.
- You will see the result that is without scientific format but with two decimal place figures.
- To get rid of these decimal places, again go to the Home tab. Then click on the Number group. After that, click on the Decrease Decimal button as in the following image.
3. Convert Number to Text Format
If you wish to put the exact data you write down in the cell, you can change the data format as text before you write down the data. To do this, you need to follow the steps below.
- First, select your cell. Then, go to the Home tab. After that, click on the Number group, and select the Text option from the drop-down menu.
- Now, type your required number at whatever length you want. Excel will not round it off.
- How to Calculate Accuracy and Precision in Excel
- How to Round Off to Nearest 50 Cents in Excel (4 Quick Methods)
- Round Down to Nearest 10 in Excel (3 Effective Ways)
- How to Round Time to Nearest 15 Minutes in Excel (6 Quick Methods)
- How to Round Time to Nearest Minute in Excel (5 Suitable Ways)
4. Increase Decimal Places
If you are working with data that includes decimal places, then by increasing the decimal place figures you can stop rounding in Excel. Because Excel provides the flexibility to decide how many digits after the decimal point you wish to show.
In order to increase decimal places, follow the steps below.
- First, under the Home tab, click on the Number group. Then, click on the Increase Decimal button as shown in the following image until your desired number appears with all the digits.
5. Format Number to Currency
Excel doesn’t want to round off numbers when it is in currency format. Here is the number in scientific format. Our goal is to stop rounding in this number.
Just follow the steps to see the magic.
- After selecting your cell that contains your number go to the Home tab, and click on the Number group. Then, select the Currency number format.
- Here is the result. Now, if you want to remove the decimals, then click on the decrease decimal button until all the decimals vanish.
In this article, we have learned 5 handy ways to stop rounding in Excel. I hope this discussion has been useful for you. If you have any questions or any kind of feedback, please don’t hesitate to let us know in the comment box. Please visit our website ExcelDemy for more Excel-related content. Happy reading!
- How to Round a Formula with SUM in Excel (4 Simple Ways)
- Round off Formula in Excel Invoice (9 Quick Methods)
- How to Roundup a Formula Result in Excel (4 Easy Methods)
- Rounding Time in Excel to Nearest Hour (6 Easy Methods)
- How to Add ROUND Formula to Multiple Cells in Excel (2 Easy Ways)
- How to Round Excel Data to Make Summations Correct (7 Easy Methods)