How To Change Dot For Comma Excel Mac

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

Using dot as decimal separator in Excel (version 2011 for Mac) Go to “System Preferences” “International” (called “Taal en tekst” in Dutch). Then go to the “Formats” tab (called “Notatie” in Dutch), and customize the number settings. Jun 24, 2019  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.

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

1. Select the data range in which you want to replacesymbols.

Note: You can select all data in the spreadsheet (seehow 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 & Selectbutton:

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

• Click Ctrl+H.

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

• In the Find what field, enter the symbol that you want to replace (in thisexample, the comma symbol),
• In the Replace with field, enter the symbol that you want to insert insteadof the replaced symbol (in this example, the decimal point symbol):
• Click:
  • Replace All - if you are sure that you need to replace all symbols in theselection,
  • 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 makea decision of replacing,
  • Find Next - if you want to find symbols step-by-step and make a decision abouteach replacement.

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