How to change dots into commas on Google Sheets

On Google Sheets there is also the option to change the dot to a comma to separate thousands in the data.

Using a dot or comma to separate thousands in a metric will depend on whether you separate decimal numbers or units of units in a series of numbers. However, many people who work on Google Sheets encounter situations that only display dots to separate thousands and commas to separate decimal rows, or vice versa. If you want to edit the thousands separator in Google Sheets, you can follow the article below.

  1. How to convert commas into dots in Excel
  2. How to change commas into dots on Word
  3. How to enter 0 in Google Sheets

Instructions for changing dots to comma Google Sheets

Step 1:

We will handle the data below, converting the dot to a comma to separate thousands in the data.

Picture 1 of How to change dots into commas on Google Sheets

First click on the File (File) section above and then click on the Spreadsheet settings . . menu at the bottom of the list.

Picture 2 of How to change dots into commas on Google Sheets

Step 2:

In the new interface, the Language (Locale) section will be returned to the United States , Time zone (Time zone) will be transferred (GMT + 07: 00) Jakarta . Finally, click the Save settings button to save the changes.

Picture 3 of How to change dots into commas on Google Sheets

As a result, we will see a sequence of data that automatically converts a dot to a comma to separate thousands in the sequence.

Picture 4 of How to change dots into commas on Google Sheets

So changing the dot to a comma on Google Sheets will help users easily distinguish data values, more accurately calculate integers or decimal numbers.

See more:

  1. How to adjust the date and currency format in Google Sheets
  2. How to set up the right to edit spreadsheets on Google Sheets
  3. How to convert the currency of each column, row in Google Sheet

I wish you all success!

« PREV
NEXT »