Content

• To step
• Method 1 of 2: Use "Search & Select"
• Method 2 of 2: Change number separators

This wikiHow teaches you how to change a comma to a period in Excel. Manually replacing commas with periods in Excel can be a time-consuming task. You can end up in this situation because European countries use commas as a decimal separator instead of a period. Fortunately, this problem can be solved quite easily.

To step

Method 1 of 2: Use "Search & Select"

1. Open the Excel spreadsheet you need to edit. Whether on your desktop or in a folder, find the spreadsheet and double-click it to open it.
2. click on Search and select. This option can be found in the top right corner of the screen. It says "Search and Select" and it is represented by a magnifying glass or binoculars, depending on the version of Excel you are using.
3. click on To replace in the menu. A menu appears and To replace is the second option to the left of an icon with an arrow between the letters "b" and "c".
4. Fill in the fields. A window will open with the two fields "Search for" and "Replace with". In the "Search for" field, type a comma. In the "Replace with" field, type a period.
5. click on Replace everything. Clicking this option will replace each comma in the document with a period.

Method 2 of 2: Change number separators

1. Open the Excel spreadsheet you want to update. Whether on your desktop or in a folder, find the spreadsheet and double-click it to open it.
2. click on File in the top left corner. The "Filebutton is always the first option on the top menu of a Microsoft Office document. You can find this in the top left corner of the window.
3. click on Options in the lower left corner. The menu on the left side of the screen will be green. At the very bottom of this menu, at the bottom left of the menu, you see Options.
4. click on Advanced in the menu on the left. A window of Excel options will appear with another menu on the left. You can choose the option Advanced find, just below Language.
5. Check the box of Use system separators from. You can select this option at the bottom of the Editing options find. The box is checked by default. Click the check mark so that it disappears and the box is unchecked.
6. Check the boxes of Decimal separator and Thousands separator if necessary. Depending on the default values, there should be a comma in one of these fields. Replace the comma with a period and click "OK" at the bottom of the window to complete the change.