en uk

Formatting Numbers and Labels Microsoft Office 2007

    When you first create a spreadsheet, numbers and labels appear as plain text. Plain labels might look boring, but plain numbers (such as 8495 or 0.39) can be difficult to read and understand if the numbers are supposed to represent currency amounts ($8,495) or percentages (39%).

    To make labels visually interesting and numbers appear more descriptive of what they actually represent, you need to format your data after you type it into a spreadsheet.

    You can format a cell or range of cells after you've already typed in data or before you type in any data. If you format cells before typing any data, any data you type in will appear in your chosen format.

    Formatting numbers

    To format the appearance of numbers, follow these steps:

    1. Select one or more cells using the mouse or keyboard.

    To select multiple cells, drag the mouse or hold the Shift key while pressing the arrow keys.

    2. Click the Home tab.

    3. Click the Number Format list box in the Number group.

    A pull-down menu appears, as shown in Figure 7-3.

    Formatting Numbers
and Labels Microsoft Office 2007

    Figure 7-3:

    The Number Format list box lists the different ways you can format the appear­ance of numbers.

    The Number group also displays three icons that let you format num­bers as Currency, Percentage, or with Commas in one click, as shown in Figure 7-4. If you click the downward-pointing arrow to the right of the Accounting Number Format icon, you can choose different currency symbols to use such as $, £, or €.

    Formatting Numbers
and Labels Microsoft Office 2007

    Figure 7-4:

    The different ways you can format money.

    4. Click a number format style, such as Percentage or Scientific.

    Excel displays your numbers in your chosen format.


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.