How to Change the Number of Displayed Decimal Places in Excel 2013

Microsoft Excel 2013 provides a lot of ways for you to change the formatting of your data. There are ways to convert text to numbers in Excel, as well as ways to change the appearance of your data. You can also learn how to change the number of displayed decimal places in Excel if there are currently too few or too many.

How to Increase the Number of Decimal Places in Excel 2013

  1. Open your spreadsheet.
  2. Select the cells to modify.
  3. Choose the Home tab.
  4. Click the Increase Decimal or Decrease Decimal button.

Our guide continues below with additional information on how to change the number of displayed decimal places in Excel, including pictures of these steps.

Excel’s default settings are perfectly fine in a lot of situations, but they can be difficult to work with if you have cells that contain large numbers, or numbers where multiple decimal places matter.

If your numbers are being rounded down or up, then this is likely due to an incorrect number of decimal places in your cell formatting. Fortunately, you can increase the number of decimal places in your Excel 2013 cells to display as many numbers after the decimal point as you need.

How to Add More Decimal Spaces in Excel 2013 (Guide with Pictures)

The steps in this guide were performed in Microsoft Excel 2013, but will also work in newer versions of excel, like the one for Microsoft 365.

If you have number cells that are mixed in with letter cells, you can still choose to select them during the process below. Increasing the number of decimal places will not affect the contents of cells that contain letters.

If you increase the number of decimal places to an amount where they are not visible, then Excel will automatically expand the width of your columns to fit the extra numbers.

Step 1: Open your Excel spreadsheet that contains the number cells for which you want to increase the number of decimal places.

Step 2: Click the Home tab at the top of the window.

click the home tab

Step 3: Use your mouse to highlight all of the cells for which you want to increase the number of decimal places.

select the cells you want to adjust

Step 4: Click the Increase Decimal button in the Number section of the ribbon until your cells are displaying the desired number of decimal places.

You could also click the Decrease Decimal button next to it if you want to reduce the number of decimal places instead.

how to change the number of displayed decimal places in excel 2013

Now that you have completed this guide you should know how to change the number of displayed decimal places in Excel. You can always use the Increase Decimal or Decrease Decimal options in the Number group of the ribbon in the future if you need to make more changes.

Is there information that you would like to display at the top of every page, but you do not want to have to merge a bunch of cells to do it? Learn how to insert a header into your Excel 2013 spreadsheet.

Additional Sources

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy