How to stop Excel from rounding
By
SpreadCheaters
Page last updated:
19/11/2022 |
Next review date:
19/11/2024
You can watch a video tutorial here.
When numbers get extremely large or small, Excel automatically uses the scientific notation to shorten the contents of the cell. If you want to change it, formatting does the job for you.
Step 1 – Right click on the cell and click on Format Cells
– Formatting Cells will change the data type of the content of the cell. As shown in cell A1, the number is too large and Excel has automatically used the scientific notation to shorten the contents of the cell.
Step 2 – Click on Number
– Changing it to a number will automatically show the entire content of the cell without rounding off.
Step 3 – Click OK to apply the changes in the selected cell.
– Click OK to apply the changes in the selected cell.
