Stop Typing Decimal Points for Currency and Other Figures
SUMMARY: Entering a large number of currency values into an Excel 2010 worksheet or other numbers that need decimal points placed in every value? Have the software add the decimal points for you.
Need to enter a large number of currency figures into a Microsoft Excel 2010worksheet by hand? To save yourself a little typing, you can configure the software to automatically add the decimal points for you.
For example, if you type the following data into cells:
Excel 2010 can add a decimal point before the penultimate numbers, turning the cell values into:
If all your data contains three decimal points, you can have Excel 2010 automatically add the decimal points after the antepenultimate numbers, and so forth.
1. Select the “File” tab in the Ribbon.
2. The Microsoft Office Backstage View appears. Click the “Options” button.
(Or instead of steps 1 and 2, press Alt + T, then the letter O.)
3. The “Excel Options” dialog box appears. Click “Advanced” in the left pane.
4. Underneath “Editing options”, check “Automatically insert a decimal point”.
5. Excel 2010 defaults to two decimal places (such as for U.S. currency). If needed, next to “Places”, change the value to the number of decimal places each number should have.
6. Click “OK” on the bottom-right of the dialog box to close it.
This feature only works if you TYPE the numbers into a worksheet. Paste the numbers from another source and Excel 2010 assumes they already have decimal points where needed.