Google Sheets: How to Replace Comma with Dot

by Published on

The easiest way to replace commas with dots in Google Sheets is by using the Find and replace function within the Edit tab.

The following example shows how to use this function in practice.

Example: Replace Comma with Dot in Google Sheets

Suppose we have the following dataset in Google Sheets that shows the average points scored by basketball players on various teams:

Suppose we would like to replace each of the commas in the Average Points column with dots instead.

To do so, highlight the cell range B2:B11, then click the Edit tab and then click Find and replace.

Note: You can also type Ctrl + H as a shortcut key to bring up the Find and replace window.

In the new window that appears, type a comma in the Find box, then type a dot in the Replace with box:

Google Sheets replace comma with dot

Then click Replace all and then click Done.

Each of the commas in the Average Points column will automatically be replaced by dots:

Note #1: Make sure you click Replace all before clicking the Done button or else the commas will not be replaced by dots.

Note #2: If you would like to perform the reverse operation (replace dots with commas) then simply type a dot in the Find box and type a comma in the Replace with box instead.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Replace #N/A Values in Google Sheets
How to Replace Text in Google Sheets
How to Replace Blank Cells with Zero in Google Sheets

2 Replies to “Google Sheets: How to Replace Comma with Dot”

  1. When I try this, all values are rounded, but I do need all digits behind the commas I want to convert to points. How do I fix this?

    Reply

    1. Hi Klaas…If your values are rounded when replacing commas with dots in Google Sheets, it’s likely because Google Sheets is interpreting the converted values as integers or formatted numbers. To keep all digits intact, follow these steps:

      —

      ### **1. Preserve the Original Format**
      If the original values (e.g., `1,234,567`) are being rounded, first check their format:
      – Select the cells.
      – Go to **Format** → **Number** → **Plain Text** to ensure they’re not treated as formatted numbers.

      —

      ### **2. Replace Commas with Dots**
      Use the **Find and Replace** feature:
      1. Select the range of cells where you want to replace commas with dots.
      2. Press **Ctrl + H** (or **Cmd + H** on Mac) to open the **Find and Replace** dialog.
      3. Set:
      – **Find**: `,`
      – **Replace with**: `.`
      – Click **Replace All**.

      This will replace the commas with dots without rounding the values.

      —

      ### **3. Double-Check Number Formatting**
      After replacing commas, check the format:
      – Select the cells.
      – Go to **Format** → **Number** → **Number** or **Automatic** to ensure they’re recognized as proper decimal numbers.

      —

      ### **4. Using a Formula for Conversion**
      If you need to keep the original column untouched, use a formula to replace commas with dots:
      1. Suppose your original values are in column `A`.
      2. In column `B`, use the formula:
      “`excel
      =SUBSTITUTE(A1, “,”, “.”)
      “`
      3. Drag the formula down for all rows.

      To keep the output as a number, wrap the formula in `VALUE`:
      “`excel
      =VALUE(SUBSTITUTE(A1, “,”, “.”))
      “`

      —

      By following these steps, your data will retain all digits after the conversion without rounding. Let me know if you need further clarification!

      Reply

Leave a Reply