Microsoft Excel 2010

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 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:

* 73832
* 94818
* 129376

Excel 2010 can add a decimal point before the penultimate numbers, turning the cell values into:

* 738.32
* 948.18
* 1293.76

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.

Return to the Microsoft Excel 2010 page.

Thanks For Sharing!



Newest Tips

Cell Phone
[MODIFIED] Six Battery Conservation Tips
Google Search Engine
What is My IP Address?
Mozilla Firefox - Misc
Missing the Title Bar? Menu Bar?
Windows 8
Bring Back the Mouse Pointer Drop Shadow

Follow/Contact Us!


About MalekTips and the Author

The MalekTips website was created in 1998 by 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.