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.

  1. Using the button on the ribbon
  2. 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