How to Automatically Add a Decimal Point in MS Excel

It’s so easy to enter numbers into an MS Excel cell and have Excel add the decimal point automatically for you.

1. Select the Excel button.
2. Select Excel Options.
3. Click and select the Advanced options.
4. Select the “Automatically insert a decimal point” check-box. Select the number of places from the drop-down list.

You’re done. If you’ve selected 2, every time you enter 12345 (for example), Excel will automatically display it as 123.45