Change the decimal places displayed for numbers
For numbers that are already entered on a worksheet, you can increase or decrease the number of places that are displayed after the decimal point by using the Increase Decimal and Decrease Decimal buttons. By default, Excel displays 2 decimal places when you apply a builtin number format, such as a currency format or a percentage, to the cells or data. However, you can change the number of decimal places that you want to use when you apply a number format. To have Excel enter the decimal points for you, you can specify a fixed decimal point for numbers.
What do you want to do?
Increase or decrease the decimal places on a worksheet

Select the cell or range of cells that contains the numbers for which you want to change the decimal places.
How to select a cell or a range
Tip To cancel a selection of cells, click any cell on the worksheet.

On the Home tab, in the Number group, do one of the following:

Click Increase Decimal to display more digits after the decimal point.

Click Decrease Decimal to display fewer digits after the decimal point.

Specify the decimal places for a builtin number format

On the Home tab, click the Dialog Box Launcher next to Number.

In the Category box, click Number, Currency, Accounting, Percentage, or Scientific.

In the Decimal places box, enter the number of decimal places that you want to display.
Note You cannot change the default setting of 2 decimal places. To use more or less than 2 decimal places, you need to change the number of decimal places every time you apply a Number, Currency, Accounting, Percentage, or Scientific format. However, you can create a custom number format that displays the number of decimals that you want. For more information, see Create or delete a custom number format.
Specify a fixed decimal point for numbers

Click the Microsoft Office Button , and then click Excel Options.

In the Advanced category, under Editing options, select the Automatically insert a decimal point check box.

In the Places box, enter a positive number for digits to the right of the decimal point or a negative number for digits to the left of the decimal point.

For example, if you enter 3 in the Places box and then type 2834 in a cell, the value will be 2.834. If you enter 3 in the Places box and then type 283 in a cell, the value will be 283000.


Click OK.

The Fixed decimal indicator appears in the status bar.


On the worksheet, click a cell, and then type the number that you want.
Note The data that you typed before you selected the Fixed decimal check box is not affected.
Tips

To temporarily override the fixed decimal option, type a decimal point when you type the number.

To remove decimal points from numbers that you already entered with fixed decimals, do the following:

Click the Microsoft Office Button , and then click Excel Options.

In the Advanced category, under Editing options, clear the Automatically insert a decimal point check box.

In an empty cell, type a number such as 10, 100, or 1,000, depending on the number of decimal places that you want to remove.

Tip For example, type 100 in the cell if the numbers contain two decimal places and you want to convert them to whole numbers.


On the Home tab, in the Clipboard group, click Copy .

Keyboard shortcut You can also press CTRL+C.


On the worksheet, select the cells that contain the numbers with decimal places that you want to change.

On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Paste Special.

In the Paste Special dialog box, under Operation, click Multiply.
