Microsoft Office Tutorials and References
In Depth Information
FORMAT
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.
P ERCENTS
1
2
Click and drag to select the
numbers you want to format.
2
Click the Percent Style button.
1
l Excel converts the numbers to a
percent.
D ATES
1
2
Click and drag to select the cells
you want to format.
1
2
Click the Number group’s
launcher.
The Format Cells dialog box
opens to the Number tab.
l
3
3
Click Date.
4
4
Click to choose a format.
5
Click OK.
156
5
 
Search JabSto ::




Custom Search