How to Setup to Insert a Decimal Point for the Last 2 Digits

In the data entry, you can automatically insert a decimal point to make your work easier. For example, when entering 555, the value in the cell automatically becomes 5.55 (2 decimals).

Step 1: Click the "File" tab from the ribbon;

Step 2: Click "Options" from the left navigation menu;

Step 3: Click "Advanced" from the left navigation menu;

Step 4: Select number "2" from the places "Automatically insert a decimal point" under the section of "Editing options";

Step 5: Click "OK" at the bottom.

Leave a Reply