See all How-To Articles

How to Add More Decimal Places in Excel & Google Sheets

This tutorial demonstrates how to add more decimal places in Excel and Google Sheets.

 

add more decimal places 1

 

Add More Decimal Places

When you apply a number format to cells and enter numbers with decimal parts, Excel will automatically round them to 2 decimal places. Say you have the following range of numbers, where every number has more than 2 decimals.

 

add more decimal places 1

 

As you can see in the picture above number in cell B2, 2.435718 is rounded to 2.44. To add more decimal places, follow these steps:

  1. Select a range with decimal numbers.
  2. In the Ribbon, go to the Home tab.
  3. Click on the Increase Decimal icon in the Number group. The more times you click, the more decimal places added.

 

add more decimal places 2

 

In this example, clicking 3 times on the icon, added 3 more decimal places.

 

add more decimal places 3

 

Note: You can also see how to limit decimals using number formats or use VBA code to format numbers.

Add More Decimal Places in Google Sheets

Similar to Excel, you can also add more decimal places in Google Sheets if a cell is formatted as a number.

  1. Select a range with decimal numbers.
  2. In the Menu, click on the Increase decimal places icon. (Here, clicking 3 times adds 3 more decimal places.)

 

google sheets add more decimal places 1

 

The result is the same as in Excel: All numbers now have 3 more decimal places.

 

google sheets add more decimal places 2