Microsoft Office Tutorials and References
In Depth Information
It Takes All Types
After fixing the decimal place in numeric values, Excel automatically adds a
decimal point to any numeric value that you enter using the number of places
you selected; all you do is type the digits and complete the entry in the cell.
For example, to enter the numeric value 100.99 in a cell after fixing the
decimal point to two places, type the digits 10099 without adding any period
for a decimal point. When you complete the cell entry, Excel automatically
inserts a decimal point two places from the right in the number you typed,
leaving 100.99 in the cell.
When you’re ready to return to normal data entry for numerical values
(where you enter any decimal points yourself), open the Advanced tab of the
Excel Options dialog box (Alt+FTA), select the Automatically Insert a Decimal
Point check box again, this time to clear it, and then click OK or press Enter.
Excel removes the Fixed Decimal indicator from the Status bar.
Tapping on the old ten-key
You can make the Fixed Decimal feature work even better when entering
numeric data on a physical keyboard that has a separate ten-key numeric
keypad. All you do is select the block of cells where you want to enter
numbers (see “Entries all around the block,” later in this chapter) and then press
Num Lock so that you can enter all the data for this cell selection from the
numeric keypad (à la ten-key adding machine).
Using this approach, all you have to do to enter the range of values in each
cell is type the number’s digits and press Enter on the numeric keypad. Excel
inserts the decimal point in the proper place while it moves the cell pointer
down to the next cell. Even better, when you finish entering the last value in a
column, pressing Enter automatically moves the cell pointer to the cell at the
top of the next column in the selection.
Look at Figures 2-4 and 2-5 to see how you can make the ten-key method
work for you. In Figure 2-4, the Fixed Decimal feature is turned on (using
the default of two decimal places), and the block of cells from B3 through
D9 is selected. You also see that six entries have already been made in cells
B3 through B8 and a seventh, 30834.63, is about to be completed in cell B9.
To make this entry when the Fixed Decimal feature is on, you simply type
3083463 from the numeric keypad.
In Figure 2-5, check out what happens when you press Enter (on either the
regular keyboard or the numeric keypad). Not only does Excel
automatically add the decimal point to the value in cell B9, but it also moves the cell
pointer up and over to cell C3 where you can continue entering the values for