Microsoft Office Tutorials and References
In Depth Information
A CCOUNTING N UMBER F ORMAT
1
Click and drag to select
the numbers to format.
2
3
2
Click the Accounting
Number Format button.
l Excel adds a dollar sign,
aligned with the left
side of the cell. Excel
reserves space for right
parenthesis if there are
negative values.
1
3
Click the Decrease
Decimal Place button.
l Each click removes a
decimal place.
l If you click the Increase Decimal Place
button, each click adds a decimal place.
C URRENCY F ORMAT
1
Click and drag to select the numbers to
format.
2
2
Click the Number group’s launcher.
1
The Format Cells dialog box opens to the
Number tab.
l
3
Click Currency in the Category box.
3
4
4
Click here and set the number of decimal
places.
5
6
5
Click here and select a currency symbol.
6
Click to select the number format for
negative numbers.
7
Click OK.
7
Excel formats your numbers.
l
Did You Know?
Changing a number format can increase the contents
of the cell. If your number is too long to fit in its cell,
Excel fills the cells with pound signs (#####). To
view the number, at the top of the column,
doubleclick the line that separates columns or click and drag
the line to make the cell wider.
Did You Know?
You can use the Text format in the Format Cells
dialog box to convert a number to text. Numbers
formatted as text should not be used in mathematical
calculations. Certain numbers — for example, employee
numbers — are never used in mathematical
calculations and should be formatted as text. If you
want to format a number as text as you type it,
precede the number with an apostrophe (‘).
Chapter 7: Present Worksheets
155
Search JabSto ::




Custom Search