Microsoft Excel: Create a Fixed Decimal Point

Most electronic calculators have an option that allows you to specify a fixed location for a decimal point. This comes in handy when you constantly work with dollars and cents. With the decimal point fixed at two places, you can enter 213 and have the calculator translate it as 2.13. Likewise, if you enter 2, the calculator translates it as 0.02.

Excel has a feature that allows you to do the same thing. To fix the number of decimal places assumed when inputting information, follow these steps:

1. From the Tools menu, select Options. Excel displays the Options dialog box.
2. Make sure the Edit tab is selected.
3. Make sure the Fixed Decimal check box is selected.
4. Using the Places control, specify how many decimal places Excel should assume.
5. Click OK when finished.

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.