How to automatically insert a decimal point to number in Excel?
Supposing you need to type multiple numbers that each one has two decimal numbers as shown as below, it will be time-waste if you type the decimal point manually. Now, I tell you a quick way to insert decimal point to number in a specific place automatically in Excel.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To insert decimal point automatically, you need to go to Options to set the decimal place.
1. Open Excel and click File (in Excel 2007, click Office button) > Options. See screenshot:
2. Then in the Option dialog, click Advanced in the left pane. See screen shot:
3. Then in the right section, find the Automatically insert a decimal point check box in the Editing options group, then check it, and specify the decimal number in the Places list. See screenshot:
4. Click OK to close the dialog. Then when you type numbers into Excel, the decimal point will be inserted automatically. See screenshot: