Microsoft Office Tutorials and References
In Depth Information
Formatting Numbers, Dates, and Time Values
✦ Accounting Number Format: Places a dollar sign before the number and
gives it two decimal places. You can open the drop-down list on this
button and choose a currency symbol apart from the dollar sign.
✦ Percent Style: Places a percent sign after the number and converts the
number to a percentage.
✦ Comma Style: Places commas in the number.
✦ Increase Decimal: Increases the number of decimal places by one.
✦ Decrease Decimal: Decreases the number of decimal places by one.
To choose among many formats and to format dates and time values as
well as numbers, go to the Home tab, click the Number group button, and
make selections on the Number tab of the Format Cells dialog box. Figure 1-7
shows this dialog box. Choose a category and select options to describe how
you want numbers or text to appear.
To strip formats from the data in cells, select the cells, go to the Home tab,
click the Clear button, and choose Clear Formats.
Entering ZIP Codes can be problematic because Excel strips the initial zero
from the number if it begins with a zero. To get around this problem, visit
the Number tab of the Format Cells dialog box (see Figure 1-7), choose
Special in the Category list, and select a ZIP Code option.