How to automatically put commas in fractional numbers in Microsoft Excel

If we are talking about writing fractional numbers in Excel, then the user will need to independently separate the fractional part from the integer using a comma. Entering such characters can take a long time when filling in a large amount of data, so I want to show how to automate this process.

When Automatically Adding Commas in Microsoft Excel Can Be Useful

It is worth noting that the setting considered in the framework of this article is rather specific and narrowly focused. When it is active, commas will automatically be added in front of several trailing digits in the numbers you enter. You need to enable it only in those cases when the table is filled with the same type of fractional numbers and it is not very convenient to separate them yourself.

You choose how many numbers you need to separate with a comma, and then you just have to enter them in the cells and press Enter for the changes to take effect. In the following instructions, you will become more familiar with this.

Turn on the automatic comma setting

This setting works only with numbers and does not apply to text values, so do not worry if you thought that its effect would be directed to absolutely all data types. Now let’s figure out how to turn on the automatic addition of commas and specify how many digits to separate.

  1. To get started, go to the “File” tab .
  2. If there is no button on the left panel “Options” , then call the menu “Others” .
  3. From there, go to the general settings of the program.
  4. Open the “Advanced” section and check the box next to “Auto insert decimal point” .
  5. Below you will see the parameter “Number of decimal places” . Choose how many digits to separate.
  6. Apply the changes and return to the table. Now enter a fractional number, but without a comma.
  7. Press Enter and make sure that the program automatically separates the fractional part from the integer, leaving the number of characters you specified after the comma.

Don’t forget to go back to settings and uncheck the same item when automatic comma is no longer needed.

With such a simple parameter, you can save a lot of time filling in a large amount of data. I hope the article was useful, and now you know more about the intricacies of working with Microsoft Excel.

Leave a Reply

Your email address will not be published.