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

Excel 365
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

See also this tip in French: Comment changer le point décimal en la virgule et vice versa dans Excel.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more