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 2010 worksheet 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.
Return to the Microsoft Excel 2010 page.
The MalekTips website was created in 1998 by Andrew Malek of Envision Programming. The page's goal is to freely disperse computer-related tips, hints, and informative articles. Tips are organized to be easy to find, and are presented clearly, in easy-to-understand language.