How to keep Excel from rounding
You can watch a video tutorial here.
Excel is frequently used for calculations and has many functions to help with basic mathematical operations. The way a number is displayed in a cell is different from the way that it is stored. Sometimes a number is stored with decimal places, but when it is displayed, it is displayed as a whole number. To get Excel to not round a number, there are 2 ways to change the way that the number is displayed.
- Using the button on the ribbon
- Using the Format Cells option
Option 1 – Use the button on the ribbon
Step 1 – Select the data
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-1-–-How-to-keep-Excel-from-rounding-1024x749.png)
- Select the data for which the rounding is to be stopped
Step 2 – Increase the decimal places
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-2-–-How-to-keep-Excel-from-rounding-1024x523.png)
- Go to Home > Number
- Keep clicking the Increase Decimal button until all the decimal places are displayed
Option 2 – Use the Format Cells option
Step 1 – Select the data
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-1-–-How-to-keep-Excel-from-rounding-1024x749.png)
- Select the data for which the rounding is to be stopped
Step 2 – Open the Format Cells window
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-2-How-to-keep-Excel-from-rounding-795x1024.png)
- Right-click and select Format Cells from the context menu
OR
Go to Home > Number and click on the arrow to expand the menu
OR
Go to Home > Cells > Format > Format Cells
OR
Press Ctrl+1
Step 3 – Enter the decimal places
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-3-–-How-to-keep-Excel-from-rounding-1024x883.png)
- On the Number tab, go to the Number category
- Enter the number of decimal places: 13
- Click OK
Step 4 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-4-–-How-to-keep-Excel-from-rounding.png)
- The numbers are displayed in their entirety without being rounded off