Microsoft Office Tutorials and References
In Depth Information
numbers, dates, and times
Excel provides a variety of options for formatting
numbers, dates, and times. Formatting makes your
data easier to read and helps you conform to company,
country, or industry standards for formatting.
The Home tab in the Number group has a number of
buttons you can use to format numbers quickly. If
you cannot find the format you need, you can click
the Number group’s launcher to open the Format
Cells dialog box.
The Format Cells dialog box has four categories you
can use to format numbers: General, Number,
Currency, and Accounting. The General format is the
default format. It displays the numbers exactly the
way you type them.
The Number format lets you apply special formats to
your numbers. You can set the number of decimal
places, specify whether your number should display a
thousands separator, and determine how to display
negative numbers. You can choose from four choices
for negative numbers: preceded by a negative
sign (–), in red, in parentheses, or in red and in
C OMMA S TYLE F ORMAT
The numbers appear in the
format you type them.
Click and drag to select the cells
Click the Home tab.
Click the Comma Style button in
the Number group.
l Excel separates the thousands in
l Excel adds two decimal places.
l Negative numbers display in
l Zeros display as a dash.