How to Replace Comma with Period in Excel

Using the Find & Select Tool

This practical guide explains how to replace comma with period in excel with clear steps and useful context. It also covers common requirements, potential problems, and the details that can help you get better results.

Click the Find & Select button. This is the button displayed in the upper right corner of the screen. This button is called 'Find & Select' and has a magnifying glass or binocular icon, depending on the version of Excel you are using.

Click Replace in the menu. A menu will appear and Replace is the second option from the top, just to the left of the arrow icon between the letters 'b' and 'c.'

Fill in the fields. The screen will display a window with two fields 'Find what' and 'Replace with'. Simply enter a comma in the 'Find what' field, and a period in the 'Replace with' field.

Click Replace All. Clicking this option will replace all commas in the document with periods.

Change Number Separator

Open the Excel worksheet that needs updating. Find the file saved on the home screen or in a folder, and double-click to open it.

Click File in the upper left corner. The File button is always the first choice at the top of the menu of Microsoft Office documents. You will see it in the upper left corner of the window.

Click Options in the lower left corner. The menu on the left side of the screen will be green. Select Options in the lower left corner of the menu.

Click Advanced in the menu on the left. The Excel Options window displays with another menu on the left. You can find the Advanced option right under Ease of Access.

Uncheck the Use system separators box. This is the option near the bottom of the Editing options section. This box is selected by default. You can remove the check mark by clicking on it and the cell will be deselected.

Update the Decimal separator and Thousands separator fields as needed. Depending on the default settings, one of these fields may contain a comma. Replace commas with periods and click 'OK' at the bottom of the window to complete the change.

Conclusion

Understanding Excel makes it easier to compare options, avoid common mistakes, and apply the information in this guide more effectively. Review the relevant requirements before making changes or choosing a solution.