Available number formats

In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers.

Select a cell or a cell range.
On the Home tab, select Number from the drop-down.

Number Formats

Or, you can choose one of these options:
- Press CTRL + 1 and select Number.
- Right-click the cell or cell range, select Format Cells… ,
  
  Format Cells
- Select the small arrow, dialog box launcher, and then select Number.
Select the format you want.

Select the Format you want

Number formats

To see all available number formats, select the Dialog Box Launcher next to Number on the Home tab in the Number group.

Number Group