How to Change a Comma to Dot in Excel

PDF download Download Article
PDF download Download Article

This wikiHow article teaches you how to change a comma to a dot in Excel. Manually replacing commas with dots in Excel can be a time-consuming task. You might run into this situation due to European countries using commas as a decimal separator instead of a period. Luckily, this issue can be fixed quite easily.

Method 1
Method 1 of 2:

Using the Find & Select Tool

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/73\/Change-a-Comma-to-Dot-in-Excel-Step-1.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/7\/73\/Change-a-Comma-to-Dot-in-Excel-Step-1.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Whether it’s on your desktop or in a folder, find the spreadsheet and double click on it to open it.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/70\/Change-a-Comma-to-Dot-in-Excel-Step-2.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/7\/70\/Change-a-Comma-to-Dot-in-Excel-Step-2.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This button can be found in the top right corner of the screen. It will say “Find & Select” and it will be represented by a magnifying glass or binoculars, depending on the version of Excel you’re using.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a3\/Change-a-Comma-to-Dot-in-Excel-Step-3.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/a\/a3\/Change-a-Comma-to-Dot-in-Excel-Step-3.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    A menu will appear and Replace will be the second option down, just to the left of an icon featuring an arrow between the letters “b” and “c.”
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/40\/Change-a-Comma-to-Dot-in-Excel-Step-4.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/4\/40\/Change-a-Comma-to-Dot-in-Excel-Step-4.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    A window will open with two fields: “Find what” and “Replace with.” In the “Find what” field, type in a comma. In the “Replace with” field, type in a period/dot.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c2\/Change-a-Comma-to-Dot-in-Excel-Step-5.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/c\/c2\/Change-a-Comma-to-Dot-in-Excel-Step-5.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Clicking this option will replace every comma in the document with a period/dot.
    6. Advertisement
Method 2
Method 2 of 2:

Changing Number Separators

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c3\/Change-a-Comma-to-Dot-in-Excel-Step-6.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-6.jpg","bigUrl":"\/images\/thumb\/c\/c3\/Change-a-Comma-to-Dot-in-Excel-Step-6.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Whether it’s on your desktop or in a folder, find the spreadsheet and double click on it to open it.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cc\/Change-a-Comma-to-Dot-in-Excel-Step-7.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/c\/cc\/Change-a-Comma-to-Dot-in-Excel-Step-7.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The File button is always the first option in the top menu of a Microsoft Office document. You can find it in the top left corner of the window.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Change-a-Comma-to-Dot-in-Excel-Step-8.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-8.jpg","bigUrl":"\/images\/thumb\/b\/bd\/Change-a-Comma-to-Dot-in-Excel-Step-8.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The menu along the left side of the screen will be green. At the very bottom of this menu, in the bottom left corner of the menu, you will see Options .
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c4\/Change-a-Comma-to-Dot-in-Excel-Step-9.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-9.jpg","bigUrl":"\/images\/thumb\/c\/c4\/Change-a-Comma-to-Dot-in-Excel-Step-9.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    A window of Excel Options will pop up that has another menu along the left side. You can find the Advanced option just beneath Ease of Access .
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1c\/Change-a-Comma-to-Dot-in-Excel-Step-10.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-10.jpg","bigUrl":"\/images\/thumb\/1\/1c\/Change-a-Comma-to-Dot-in-Excel-Step-10.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can find this option near the bottom of the Editing options section. The box should be checked by default. Click on the check mark so that it disappears, and the box is unchecked.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b9\/Change-a-Comma-to-Dot-in-Excel-Step-11.jpg\/v4-460px-Change-a-Comma-to-Dot-in-Excel-Step-11.jpg","bigUrl":"\/images\/thumb\/b\/b9\/Change-a-Comma-to-Dot-in-Excel-Step-11.jpg\/aid11118440-v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-11.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Depending on what your defaults are, one of these fields should have a comma in it. Replace it with a period/dot and click “OK” at the bottom of the window to complete the change.
    7. Advertisement


Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Unprotect an Excel Sheet
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Unhide Multiple Rows in Microsoft Excel
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Add a Column or Calculated Field in an Excel Pivot Table
      The Best Ways to Make & Format Lists in Excel
      How to
      Add a Best Fit Line in Excel
      Advertisement

      About This Article

      Article Summary X

      1. Open the desired Excel spreadsheet.
      2. Click on the Find & Select button.
      3. Click Replace from the menu.
      4. Fill out the "Find what" and "Replace with" fields.
      5. Click Replace All .

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 244,013 times.

      Is this article up to date?

      Advertisement