Microsoft Office Tutorials and References
In Depth Information
Formatting Numbers and Labels
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.
To format the appearance of numbers, follow these steps:
1. Select one or more cells by 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 8-3.
box lists the
The Number group also displays three icons that let you format
numbers as Currency, Percentage, or with Commas in one click, as shown
in Figure 8-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 €.