Microsoft Office Tutorials and References
In Depth Information
Changing Cell Formats
Increase Decimal Decrease Decimal
The Format Cells dialog box.
Easily add or remove decimal places.
The Format Cells dialog box allows you to select
from several number formatting styles, including
choosing whether to display negative numbers in
red, choosing the number of decimal points, and
even selecting the desired type of currency symbol.
There is also a Special category where you can
format numbers to match the pattern for telephone
numbers or social security numbers.
Column Too Narrow
If a formatted value cannot fit within the
width of a cell, Excel may display a series of
### or it may automatically round the
value. You discover how to widen a column
later in this chapter.
As mentioned earlier, by default, the Comma and
Currency styles include two decimal places, and
percentages don't include decimal points. If you have a
number in a formatted cell with more than the two
decimal points, Excel rounds up the number. So if
you enter 75.257 in a cell, then format that cell to
comma or currency, Excel displays $75.26. There are
Ribbon buttons, however, that allow you to increase
or decrease the number of decimal places. Excel
numbers can display up to 30 decimal places.
To remove digits to the right of the decimal point,
choose Home>Number>Decrease Decimal. Each
click removes a number from the far right of the
decimal point and rounds the value in the cell.
Designing with Fonts
Excel uses a default font of Calibri, but from the
Home tab of the Ribbon you can easily change the
font typeface, size, and style. Fonts are typefaces in
different styles that give your text character and
impact. Your selection of fonts varies depending on
the software installed on your computer.
Select the cells you want formatted and choose
Home>Number>Increase Decimal. Each click of
the button adds another decimal digit to the right
of the decimal point (see Figure 10-4).