How To Add Decimal Places Automatically In Excel

Add Decimal Places Automatically In Excel

You have to deal with the decimals when you’re working with data in Excel, especially if you’re working with currency data or accounting numbers. There are some inbuilt features that make the use of excel easy. You will face some issues while working with decimals such as if you type 10.00 it will be automatically converted to 10. It is better to use a specific format while using excel, even if the decimals have zeros. You can apply decimal points in all numbers automatically. You won’t have to manually select the cells with numbers then change into decimals. Here are the steps to add decimal places automatically in excel.

Add Decimal Places Automatically In Excel

Add Decimal Places Automatically In Excel

  • Click the File tab.
  • Click on Options.
  • Click on the ‘Advanced’ option from the left pane.
  • Enable the setting “Automatically insert or decimal point”.
  • The number after the decimal points can be specified (the default being 2).
  • Click OK.

Any number will be automatically converted into decimal points after this setting is enabled. For example, if you enter 1, it would be converted into .01. If you enter 1234 in a cell, it would automatically be converted into 12.34.