Microsoft Office Tutorials and References
In Depth Information
numbers, dates, and times
The Currency format offers you the same options as
the Number format except you can choose to display
a currency symbol. The currency symbol you choose
determines the options you have for displaying
negative numbers. If you choose the dollar sign ($),
thousands are separated by commas by default.
Excel designed the Accounting format to comply with
accounting standards. If you use the dollar sign
symbol ($), the dollar sign displays aligned with the
left side of the cell, decimal points are aligned, a
dash (–) displays instead of a zero, and negative
values display in parentheses.
Countries vary in the way they display dates and
times. Use the Date and Time format option to
choose a locale. If you choose English (U.S.), you
have more than 15 ways to display a date and a
variety of ways to display time. To learn more about
dates and times, see Task #s 22 and 23.
The percentage option converts numbers to a
percent. You can choose the number of decimal
places you want to display. The fraction option
converts numbers to a fraction.
Click and drag to select the
numbers you want to format.
Click the Percent Style button.
l Excel converts the numbers to a
Click and drag to select the cells
you want to format.
Click the Number group’s
The Format Cells dialog box
opens to the Number tab.
Click to choose a format.