(Legacy) Microsoft Excel 2007: Formatting Numbers

Last Updated

Note: This article is based on legacy software.

Excel provides preset number formats to help you standardize how numbers will appear in your worksheet. You may also customize number formats to fit your needs.

EXAMPLES:
When formatted as Currency, the number 9.27 will appear as $9.27.
When formatted as Fraction, the number 9.27 will appear as 9 1/4.

Formatting Numbers: Toolbar Option

When you want to format numbers quickly, Excel allows you to do so from the Ribbon.

  1. Select the cell(s) you want to format.

  2. From the Home command tab, in the Number group, click the desired toolbar option.

NameImageDescriptionNumber FormatgeneralDisplays the formatting style of the selected cell.
NOTE: For more information, refer to Formatting Numbers: Ribbon Option below.Accounting Number Formataccounting number formatChanges the formatting to Accounting.
NOTE: You can insert foreign currency symbols by clicking the arrow .Percentage Stylepercentage styleChanges the formatting to Percentage.Comma Stylecomma styleChanges the formatting to include commas and two decimal places.Increase Decimalincrease decimalAdds one decimal place to the selected cell.Decrease Decimaldecrease decimalRemoves one decimal place from the selected cell.Format Cells: Numberformat cells numberAccesses the Format Cells dialog box.
For more information, refer to Formatting Numbers: Dialog Box Option below.

Formatting Numbers: Ribbon Option

The Ribbon offers a simple way to apply number formatting. To customize number formatting, refer to Formatting Numbers: Dialog Box Option below.

  1. Select the cell(s) you want to format.

  2. From the Home command tab, in the Number group, click Number Format number format » select the desired number format
    The cell is formatted.
    HINTS:
    The default category is General.
    The number in the selected cell is previewed under the format label in the pull-down list.

Formatting Numbers: Dialog Box Option

The Format Cells dialog box can help you customize your number formatting.

  1. Select the cell(s) you want to format.

  2. In the Home command tab, in the Number group, click Format Cells: Number. format cells number
    The Format Cells dialog box appears with the Number tab displayed.

  3. From the Category list, select the desired number format.
    HINT:You can preview the formatting in the Sample section.
    EXAMPLE: Select Currency.

  4. If the format offers additional options, select the preferred options.
    EXAMPLE: Format the number of decimal places, the desired symbol, and negative numbers.
    format cells

  5. Click OK.
    The selected cells are formatted.

Clearing Number Formatting

The General number format is the default selection. Changing the formatting to General will remove all other number formatting for the selected cells.

  1. Select the cell(s) you want to format.

  2. From the Home command tab, in the Number group, click Number Format number format » select General.
    The formatting is cleared.