"Offering free computer help, hints, and tips to the Internet populace." Now with over 3,820 tips!

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.

Print this tip


Get the Newsletter

blog comments powered by Disqus

Thanks For Sharing!



Newest Tips:

Google Chrome
[MODIFIED] Add Button to Scroll to Top of Long Web Pages
Google Gmail
Show Maps Automatically in Emails Instead of Copying and Pasting
Windows 8
Shrink the Taskbar Buttons
Sites to Browse - DVDs - Movies
[MODIFIED] Learn to Talk like Yoda

Follow Us!

About MalekTips and the Author

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. MalekTips also provides information and links to public-domain, open source, freeware, shareware, and commercial software available for download.