This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2007

Formatting Numbers

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.

return to topFormatting 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

Name Image Description
Number Format Number Format Displays the formatting style of the selected cell
NOTE: For more information, refer to Formatting Numbers: Ribbon Option.
Accounting Number Format Accounting Number Format button Changes the formatting to Accounting
NOTE: You can insert foreign currency symbols by clicking theDown arrow.
Percentage Style Percentage Style button Changes the formatting to Percentage
Comma Style Comma Style button Changes the formatting to include commas and two decimal places
Increase Decimal Increase Decimal button Adds one decimal place to the selected cell
Decrease Decimal Decrease Decimal button Removes one decimal place from the selected cell
Format Cells: Number Format Cells: Number Accesses the Format Cells dialog box
For more information, refer to Formatting Numbers: Dialog Box Option.

return to topFormatting Numbers: Ribbon Option

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

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

  2. From the Home command tab, in the Number group, click NUMBER FORMATNumber Format button» 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.

return to topFormatting 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: NUMBERFormat 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 dialog box: Number Tab

  5. Click OK
    The selected cells are formatted.

return to topClearing 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 FORMATNumber Format button» select General
    The formatting is cleared.

Excellence. Our Measure. Our Motto. Our Goal.