How to Automatically Insert a Decimal Point in Excel?

When you work on a Microsoft Excel worksheet, you do data entry in a worksheet, and You have entry countless cells or all of the numbers that come with decimals of 2 or 3 or something else. You can avoid pressing the period sign to enter the decimal point in every entry in this situation.

You want a setting that makes decimal points automatically. This rise windows article will guide you on how to Insert a Decimal Point in Excel Automatically.

There are at least two methods for Automatically Inserting a Decimal Point in Excel.

  1. using Excel Options
  2. using Registry Editor

We will review both ways in this post.

How to Automatically Add a Decimal Point in Excel using Excel Options?

To automatically insert decimal points in Excel, do the following steps:-

Step 1. Firstly, open Microsoft Excel on your computer.

Step 2. Next, click on the File menu.

Microsoft-Excel-Worksheet-File-menu

Step 3. Then, click the Options in backstage.

Excel-File-Options

Step 4. After that, Switch to the Advanced tab when the Excel Options window appears.

Excel-Options-Advanced

Step 5. Check the option, “Automatically insert a decimal point.”

Excel-Options-Places-1024x839

Step 6. Then, enter the Places and click the OK button.

Now, let me see in an example how it works. By default, Places is set to 2. So, if you enable the “Automatically insert a decimal point” when you type 1234, it will automatically change to 12.34. In case you want to make it 1.234, you’ll need to enter 3 in the Places value.

How to Automatically Add Decimal Points in Excel using Registry Editor?

To automatically add decimal points in Excel using Registry Editor, do the following steps:-

Step 1. Open the Registry Editor.

Step 2. Next, navigate to the following path in the Registry Editor:-

HKEY_CURRENT_USER\Software\Policies\Microsoft\office\16.0

Registry-Editor-16.0

Step 3. After that, right-click on the 16.0 folder and select New > Key.

Device-Manager-HID-compliant-touch-screen-1024x750

Step 4. Next, Name the newly created key as excel.

Registry-Editor-excel

Step 5. Then, you’ll need to create one more key under excel. For that, right-click the excel folder and select New > Key. Then, name it as options.

Registry-Editor-options

Step 6. Then , right-click on the options folder and select New > DWORD (32-bit) Value.

New-DWORD-on-options-folder

Step 7. Now, Set its name as autodec.

Registry-Editor-autodec-1024x728

Step 8. Double-click on autodec to set the Value data per your requirements. For example, if you want to put the decimal point after 4 digits, you’ll need to enter 4.

autodec-value-data-1024x728

Step 9. Then, Click the OK button.

Step 10. After that, reboot your PC to apply the changes.

That’s all for this article. I hope this article will add some value to your work.

You guys are amazing; Keep reading, learning, and growing.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: