How to Stop Excel from Rounding Up Decimals (4 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

We frequently round Excel numbers to make them easier to understand. However, when working with sensitive data, it can be inaccurate. Simple fractional changes can have a significant impact on the entire project. So, in this tutorial, we will show you how to stop Excel from rounding up decimals.


How to Stop Excel from Rounding Up Decimals: 4 Simple Methods

We’ve provided a data set in the image below that shows rounded numbers to two decimal places, though our actual numbers go up to five decimal places. We’ll use Excel basics like adjusting column width, changing the number format, and customizing the Format Cell box to stop Excel from rounding up the decimals.

Sample Data

1. Adjust Column Width to Stop Excel from Rounding Up Decimals

Excel may not display the numbers in full decimals due to a lack of column width. It could appear as a rounded number or as a (###) sign. To get the number in whole decimals, you need to adjust the column width.

Simple Methods to Stop Excel from Rounding Decimals

⇒ Steps: Adjust Column Width

  • Click, hold, and drag in the column margin until the number appears in full decimal format.
  • Or, simply double-click the column margin to make changes.

Simple Methods to Stop Excel from Rounding Decimals


2. Alter Number Format to Stop Excel from Rounding Up Decimals

For large numbers, if the number is in General Format, Excel will not display the number in full decimal. It will appear as if we are showing the scientific number, as shown in the image below. The number format should be changed from General to the Number.

Simple Methods to Stop Excel from Rounding Decimals

⇒ Steps: Change Cell Format

  • From the Number Group, select the Number format instead of General.

Simple Methods to Stop Excel from Rounding Decimals

  • As a result, you’ll notice that the numbers are displayed in their entirety.

Simple Methods to Stop Excel from Rounding Decimals

Read More: How to Remove Decimals in Excel with Rounding


Similar Readings


3. Utilize Format Cells Dialog Box to Stop Excel from Rounding Up Decimals

You can select how many digits to display the numbers from the Format Cells box. So, you can type the number of decimal places you want to see from there. Furthermore, it will apply to all types of numbers, such as accounting and currency.

⇒ Steps: Utilize Format Cells Box

  • Select the cells you want to show the numbers in full decimals.

Simple Methods to Stop Excel from Rounding Decimals

  • Press  Ctrl +  1  to open the Format Cell box.
  • From the Number tab, choose any of the number categories (Number, Accounting, or Currency).
  • In the Decimal Places box, type the number of decimal places (5).
  • In the Sample box, you can see a preview of the change.
  • Then, click OK.

Simple Methods to Stop Excel from Rounding Decimals

  • Therefore, the number will show up to the 5 decimal places.

Simple Methods to Stop Excel from Rounding Decimals

  • For currency, choose the Currency from the Number tab.
  • Type the decimal place number in the Decimal places box.
  • You can choose a preferred currency sign ($=USD) from the Symbol box.
  • Finally, press Enter.

Simple Methods to Stop Excel from Rounding Decimals

  • As a result, the number will be displayed with 5 decimal places and the USD ($) symbol.

Simple Methods to Stop Excel from Rounding Decimals

Read More: How to Stop Excel from Rounding Large Numbers


4. Stop Excel from Rounding Up Decimals for More Than 15 Digits

Excel does not allow digits after 15 digits to be displayed by default. After 15 digits, it displays zero (0) for the last digits. Follow the steps outlined below to display the full number with more than 15 digits.

Sample Data

⇒ Steps: Add an Apostrophe

  • After adding the apostrophe (‘) sign before the number, type the number.
  • Press Enter.

Sample Data

  • To eliminate the error, click on the left-hand icon for the error.
  • Click on the Ignore Error option from the list.

Sample Data

  • Finally, the number will appear in its entirety.

Sample Data

Read More: How to Stop Rounding in Excel


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

I hope this article has given you a tutorial about how to stop Excel from rounding up decimals. All of these procedures should be learned and applied to your dataset. Take a look at the practice workbook and put these skills to the test. We’re motivated to keep making tutorials like this because of your valuable support.

Please contact us if you have any questions. Also, feel free to leave comments in the section below.

We, the ExcelDemy Team, are always responsive to your queries.

Stay with us and keep learning.


Related Articles

Bhubon Costa
Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo