How To Add More Decimal Places In Excel & Google Sheets

Home » Add Decimal Excel Formula » How To Add More Decimal Places In Excel & Google Sheets

Maybe your like

See all How-To Articles

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on November 10, 2022

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

AI Formula Generator

Try for Free

AI Tools

  • Excel Help Bot
  • Formula Generator
  • Formula Explainer
  • VBA Code Generator
  • VBA Code Commenter
  • Excel Template Generator

See all How-To Articles

← How to Move Decimal Places in Excel & Google SheetsHow to Add Units to Numbers in Excel & Google Sheets →

Try our AI Formula Generator

Generate =SUMIF(A:A, "Q1", B:B)

Tag » Add Decimal Excel Formula