Number Format

Use the Number Format panel to set the number format for a cell or range.

Format as Number

Format as Percent

Format as Currency

To apply a different currency format, click the Format as Currency icon, select a currency from the list, and click OK.

Category

Select a default format from the dropdown list.

Decimal places

Leading zeroes

Negative numbers red

Thousands separator

Engineering notation