Microsoft Office Tutorials and References
In Depth Information
Automatically Insert a Decimal Point
Chapter 1: Making Excel More Efficient
4 Click to select the
Automatically Insert a
Decimal Point check box.
5 Use the Places spin box
to specify the number of
decimal places you want
Excel to add automatically.
6 Click OK.
4
5
Excel now automatically
inserts the number of
decimal places you
specified when you enter
a numeric value into a
cell.
Excel displays Fixed
Decimal in the status bar
to remind you that it will
automatically insert the
decimal point.
Did You Know?
Even in Fixed Decimal mode, Excel still
drops trailing zeroes from your cell
entries. For example, if you choose 2 in
the Places spin box and you then enter
12340 in a cell, Excel displays the entry
as 123.4. If you always want to see two
decimal places — that is, 123.40 —
then you must format the cells using a
two-decimal numeric format, such as
Number or Currency.
Try This!
If you choose a number other than 2 in the
Places spin box and you always want Excel
to display that number of decimal places,
you must format the cells with a custom
numeric format. In the Home tab, click the
dialog box launcher in the Number group. In
the Category list, click Custom, and then in
the Type text box type 0 , a decimal point (.),
and then a 0 for each decimal place that you
want displayed. For example, the format
0.000 always displays three decimal places.
 
Search JabSto ::




Custom Search