Format Numbers

You can use a variety of formatting features to change a number’s appearance. Use the Home Tab/Number Group to do the following:

• choose a category of number (currency, percentage, date, etc.)
• choose a style (decimals, commas, etc.)

You can also format numbers in the Home Tab/Cells Group/Format dialog box.

Format Cells

1. Select the cell(s) to configure.
2. Navigate to the Home Tab/Cells Group/Format dialog box.
3. Choose Format Cells.
   1. Click on the Number tab.
   2. Select the appropriate Category on the left side in the dialog box.
   3. Choose any additional information for that category contained on the right side of the dialog box.

   

4. Click OK

Format Number

1. Select the cell(s) to configure.
2. Navigate to the Home Tab/Number Group.
3. Select the appropriate format or select the drop down arrow to access the Format Cells dialog box.
   

EXCEL EXTRAS

You can also perform basic number formatting using the icons on the ribbon.