The Power

        Sometimes, we need to multiply numbers by ten to the x powers.  For example, we want to multiply all numbers we enter in a cell by ten to the 5^th power, if we entered the number 1 in a cell, it will become 100000.  Excel can make this easy by clicking Options inside the Office button.  Click Advanced, and then under Editing options, select the Automatically insert a decimal point check box.  In the Places box, enter a positive number for digits to the right of the decimal point or a negative number for the digits to the left of the decimal point.  For example, if you want to turn 100 into 1 automatically, enter 2 in the Places box as mentioned earlier.  Or 100 into 10000, just put a negative number like -2.  It’s just easy!