How to change the number of decimal places displayed in Excel?

Contents
  1. There are several ways to do this
  2. Decimal Increase and Decimal Decrease Buttons
  3. Specify decimals for built-in number formats
  4. Specify a fixed decimal point for all numbers on a worksheet

There are several ways to do this

Excel allows you to control the number of decimal places to display when you have non-integer numbers. Options for displaying decimals in Excel include:

  • Modify existing data using the toolbar

  • Set number of decimal places for existing data or empty cells using Number Format dialog

  • Change the default number of decimal places displayed in all cells on a worksheet

Remark † These instructions apply to Excel 2019, 2016, 2013, 2010, Excel for Mac, Excel Online, and Excel for Office 365.

Decimal Increase and Decimal Decrease Buttons

For numbers that you have already entered on the worksheet, you can increase or decrease the number of decimal places displayed using the toolbar buttons.

  1. Select the cells you want to format.

  2. Click on the tab At home on the tape.

  3. Press the button Increase decimal or Decrease decimal in a group of numbers to increase or decrease the number of decimal places. Each click adds or removes a decimal number.

Specify decimals for built-in number formats

In desktop versions of Excel, you can create your own decimal rules for various built-in number types using the Number Format dialog box.

  1. Select the cells you want to format.

  2. Click on the tab At home on the tape.

  3. Click the arrow next to the list of number formats in the number group and select Additional number formats at the bottom of the drop-down list.

  4. Select Currency, Accounting, Percentage, or Scientific in the category list.

  5. In the Decimals field, enter the number of decimal places you want to display.

Specify a fixed decimal point for all numbers on a worksheet

To let Excel automatically enter decimals, you can specify a fixed decimal point for all numbers on a worksheet.

Excel Online does not have this feature.

  1. Open a tab File

  2. Click parameters: to open the Excel Options window.

  3. Click Additionally on the left panel.

  4. Check box Automatically insert decimal point in the Edit Options section.

  5. Enter the number of decimal places you want to display in the Labels field and click Okay

  6. Enter the numbers you want to use in a cell on the worksheet.

Changes are not applied to data entered before you select a fixed decimal number.

Leave a Reply

Your email address will not be published.