Why Is Excel Only Showing Two Decimal Places?

Excel can be used for many purposes, including ones where you need to store numbers to a high degree of specificity. This often involves entering numerical values that contain a high number of decimal places. But you might notice that Excel is rounding these numbers are after only a couple of decimal places, and your current project might dictate that this is a problem.

Fortunately you are able to change the number of decimal places being shown in an Excel cell by changing the format of that cell and choosing the number of decimal places that it displays. Our tutorial below will show you where to find and adjust that setting.

 

How to Change the Number of Displayed Decimal Places in Excel

The steps in this article were performed in Microsoft Excel 2013, but will work in other versions of Excel as well. By completing the steps in this guide you will be changing the formatting for a cell. if you apply this formatting to multiple cells, Excel will display the same number of decimal places for all of those cells. If the number has a lower number of decimal places than the amount it has been formatted to display, Excel will show a number of zeroes equal to the amount of decimal places you have set it to display.

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Select the cell(s) for which you wish to change the number of displayed decimal places.

why is excel only showing two decimal places

 

 

Step 3: Right-click one of the selected cells, then choose the Format Cells option.

excel format cells

 

 

Step 4: Select the Number option from the column at the left side of the window, then adjust the Decimal Places field value to the number of decimal places you want. Click OK at the bottom of the window when you’re done.

how to change number of decimal places in excel

 

 

You can also increase the number of decimal places by clicking the Increase Decimal button in the Number section of the ribbon.

excel increase decimals

 

 

Are you having trouble getting your spreadsheet to print correctly? Our Excel printing guide will show you some settings that can improve the look of your spreadsheet when it’s printed on paper.

Recent Articles