Getting Fixed Decimals

If you have to enter in lots of numbers to show currency or numbers requiring a fixed decimal such as two places to the left or more than two places, Excel can do this for you automatically. By using this feature in Excel, you can use your numeric keypad to enter those numbers in and save a key stroke on having to hit the period or decimal key. Just follow these instructions:

This feature can be enabled or disabled. The default is disabled. Also, check out the other features on this option menu, Excel gives you the capability to change calculations, colors, data transition types, and much more.
home button   Just click on the button for the Tiproom's Home Page.
Date of last revision: 29 August 2001.