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

this column.