Number Formatting in Excel

In Excel, you have a selection of formatting numbers within cells for data types such as currency, percentages, dates, or phone numbers.

  • Choose a cell or a cell range.
  • Select Number from the drop-down, coming from the Home tab.

Number Formats

  • Or, you can follow one of these options:
  • Press CTRL + 1 and click Number.
  • Right-click the cell or cell range, choose Format Cells…, and press Number.
  • Click the dialogue box launcher beside Number and then press Number.
  • Decide the format you want.

Number Formats

To view all accessible number formats, select the Dialogue Box Launcher beside the Number on the Home in the Number group.

%d bloggers like this: