Microsoft Office Tutorials and References
In Depth Information
Session 3.1
Figure 3-6
Number format categories
Category
Description
General
Default format that displays numbers as they are entered
Number
Used for a general display of numbers, with options for the formatting of negative
numbers and the number of decimal places
Accounting
Used for displaying monetary values with dollar signs aligned at the left edge of the
cell, the decimal points aligned vertically, and comma separators inserted
Currency
Used for displaying monetary values with dollar signs aligned next to leftmost digit
and comma separators inserted (decimal points are not aligned)
Date, Time
Used for displaying date and time values
Percentage
Used for displaying decimal values as percentages
Fraction, Scientific
Used for displaying values as fractions or in scientific notation
Text
Used for displaying values as text strings
Special
Used for displaying ZIP codes, phone numbers, and social security numbers
Custom
Used for displaying numbers used in coding or specialized designs
As shown in the Format Cells dialog box in Figure 3-5, the Accounting format displays
numbers with a dollar sign, a comma separator, and two decimal places. The Currency
format is similar to the Accounting format. When you apply the Currency format to a
number, the number appears with a dollar sign, a comma separator, and two decimal
places. However, the difference between the two formats is how these attributes appear in
the cell. The Accounting format lines up the decimal points and aligns the dollar signs at
the left edge of the cell border (creating blank spaces between the dollar signs and the
values, as you saw earlier). The Currency format aligns the dollar sign closer to the num-
ber, which removes the blank spaces. Joan prefers the Currency format, so you will apply
this format to the nonadjacent range that you already selected.
To modify and apply the Currency format:
1. On the Number tab, click Currency in the Category list box. The Format Cells dialog box
displays the options available for customizing the Currency category and provides a pre-
view of the selected format. As shown in the Negative numbers list box, Excel displays neg-
ative currency values either with a minus sign (-) or with a combination of a red font and
parentheses. Joan wants negative currency values to be displayed with a minus sign, which
is one of the variations of the Currency format available to you.
2. Click the first entry in the Negative numbers list box, and then click the OK button. Excel
changes the format of the currency values, removing the blank spaces between the dollar
signs and the values and changing the alignment of the decimal points.
By using the Format Cells dialog box, you can control the formatting to ensure that text
and values are displayed the way you want them to be.
Changing Font Type, Size, Style, and Color
A font is a set of characters that use the same typeface, style, and size. A typeface is the spe-
cific design of a set of printed characters, including letters, numbers, punctuation marks, and
symbols. Some of the more commonly used fonts are Arial, Times Roman, and Courier. Each
Search JabSto ::




Custom Search