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

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×