Change the number format of datasheet cells or chart items

  1. To format cells, click View Datasheet Button image if you need to display the datasheet, and then select the cells you want to change.

    How?

    To format a chart item, such as data labels or an axis, click the chart item you want to change.

    How?

  2. Click the button for the format you want.

    To select another format, click Number on the Format menu.

To display

Click

Commas to separate thousands

Comma Style

Button image

Currency symbol

Currency Style

Button image

Numbers as percentages of 100

Percent Style

Button image

Fewer digits after the decimal point

Decrease Decimal

Button image

More digits after the decimal point

Increase Decimal

Button image

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×