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


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


  2. Click the button for the format you want.

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

To display


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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!