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.

Whether its on your desktop or in a folder, find the spreadsheet and double click on it to open it.

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 youre using.

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.

A window will open with two fields: Find what and Replace with.

The File button is always the first option in the top menu of a Microsoft Office document.

At the very bottom of this menu, in the bottom left corner of the menu, you will see Options.

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.

You can find this option near the bottom of the Editing options section.

Click on the check mark so that it disappears, and the box is unchecked.

Depending on what your defaults are, one of these fields should have a comma in it.

Replace it with a perioddot and click OK at the bottom of the window to complete the change.

Open the desired Excel spreadsheet.

Click on the Find Select button.

Click Replace from the menu.

Click Replace All.

By continuing to use our site, you agree to our cookie policy.

But with the arrival of COVID-19, the stakes are higher than ever.

Every dollar contributed enables us to keep providing high-quality how-to help to people like you.

Please consider supporting our work with a contribution to wikiHow.

How To Change Dot For Comma Excel Mac