Breaking News: Grepper is joining You.com. Read the official announcement!

google sheets replace dot with comma

Concerned Cow answered on February 5, 2022 Popularity 8/10 Helpfulness 10/10

answer google sheets replace dot with comma

related google sheets replace comma with dot

google sheets replace dot with comma

Comment

=SUBSTITUTE("text.text"; ".", ",")

Popularity 8/10 Helpfulness 10/10 Language typescript

Source: Grepper

Tags: dot google-sheets replace typescript

Link to this answer
Share Copy Link

Contributed on Feb 05 2022

Concerned Cow

0 Answers Avg Quality 2/10

Closely Related Answers

google sheets replace comma with dot

Comment

function replaceCommaWithDot() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();
  var numRows = values.length;
  var numCols = values[0].length;

  for (var i = 0; i < numRows; i++) {
    for (var j = 0; j < numCols; j++) {
      if (typeof(values[i][j]) === 'string') {
        values[i][j] = values[i][j].replace(/,/g, '.');
      }
    }
  }

  range.setValues(values);
}

Popularity 7/10 Helpfulness 2/10 Language python

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

google sheets replace dot with comma

Contents

More Related Answers

google sheets replace dot with comma

Closely Related Answers

google sheets replace comma with dot

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.