How to change comma to decimal point and vice versa in Excel

Excel 2016
Because of different standards of different countries and cultures, there is a lot of situations when you need to change commas to dots, decimal points or dots, decimal points to commas in an Excel spreadsheet:
Change comma to decimal point and vice versa in Excel 2016

To change the global settings for using commas instead of decimal points and vice versa, see Change the decimal point to a comma or vice versa in Excel.

To replace commas to dots or any other symbol that you use as a decimal point separator in the Excel spreadsheet, do the following:

   1.   Select the data range in which you want to replace symbols.

Note: You can select all data in the spreadsheet (see how to do it by one click) or only a specific data range (or ranges).

For this example, column B was selected.

   2.   Do one of the following:

  • On the Home tab, in the Editing group, click the Find & Select button:
    Find and Select button in Excel 2016

    From the Find & Select dropdown list, choose Replace...:

    Replace command in Excel 2016
  • Click Ctrl+H.

   3.   In the Find and Replace dialog box, on the Replace tab:

  • In the Find what field, enter the symbol that you want to replace (in this example, the comma symbol),
  • In the Replace with field, enter the symbol that you want to insert instead of the replaced symbol (in this example, the decimal point symbol):
    Find and Replace dialog box in Excel 2016
  • Click:
    • Replace All - if you are sure that you need to replace all symbols in the selection,
    • Replace - if you want to replace them step-by-step,
    • Find All - if you need to find all symbols to be replaced and after that make a decision of replacing,
    • Find Next - if you want to find symbols step-by-step and make a decision about each replacement.

After replacing all symbols, Excel shows the dialog box with the number of replacements:

Microsoft message in Excel 2016

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.