Show All

Change the number of decimal places displayed

On a worksheet

1. Select the cells you want to format.

2. To display more or fewer digits after the decimal point, click Increase Decimal or Decrease Decimal on the Formatting toolbar.

In a built-in number format

1. On the Format menu, click Cells, and then click the Number tab.

2. In the Category list, click Currency, Accounting, Percentage, or Scientific.

3. In the Decimal places box, enter the number of decimal places you want to display.

4. If you want to change the currency symbol, click the symbol you want to use in the Symbol list.