Speed Up Data Entry Decimal Numbers in Excel

How to speed up data entry of decimal numbers
Data entry is the starting point of any work in a computer application. We can speed up the data entry of decimal numbers in an Excel worksheet by using a simple feature.

Description of the process:

1. Click on Microsoft Office Button
2. Click on Excel Options…
3. In the Excel Options window we click on Advanced
4. In the Editing Options area check the box next to ‘Automatically insert a decimal point’
5. Next to ‘Places’ select ‘2’, for example
6. Click on the OK button
7. Now enter a value like 8907 in cell C4 and press enter
8. The value 8907 is automatically formatted to 89.07

Watch the video below to see how the idea is implemented:

Further reading:
Fast Data Entry Techniques in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *