How to get Excel to stop 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 stop rounding, 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
- Select the data for which the rounding is to be stopped
Step 2 – Increase the decimal places
- 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
- Select the data for which the rounding is to be stopped
Step 2 – Open the Format Cells window
- 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
- On the Number tab, go to the Number category
- Enter the number of decimal places: 13
- Click OK
Step 4 – Check the result
- The numbers are displayed in their entirety without being rounded off