en uk

Displaying negative numbers Microsoft Office 2007

    Because many people use spreadsheets for business, they often want negative numbers to appear highlighted so they can see them easier. Excel can display negative numbers in parentheses (-23) or in red so you can't miss them.

    To define how negative numbers appear in your spreadsheet, follow these steps:

    1. Select the cell or range of cells that you want to modify.

    2. Click the Home tab.

    3. Click the Format icon in the Cells group.

    A pop-up menu appears, as shown in Figure 7-5.

    4. Choose Cells.

    The Format Cells dialog box appears, as shown in Figure 7-6.

    5. Choose Currency or Number from the Category list.

    You can choose how to format negative numbers only if you format your numbers using the Currency or Number category.

    Displaying
negative numbers Microsoft Office 2007

    Figure 7-5:

    The Format icon lets you format the appearance of rows, columns, or individual cells.

    6. Click a negative number format and then click OK.

    If any of your numbers become negative in the cell or cells you selected in Step 1, Excel automatically displays those negative numbers in the negative number format you chose.

    Displaying
negative numbers Microsoft Office 2007

    Figure 7-6:

    The Format Cells dialog box lets you

    Customize the appear­ance of your

    Numbers.




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.