How to Replace Comma with Period in Excel

Using the Find & Select tool

How to Replace Comma with Period in Excel Picture 1

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.

How to Replace Comma with Period in Excel Picture 2

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.

How to Replace Comma with Period in Excel Picture 3

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.'

How to Replace Comma with Period in Excel Picture 4

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.

How to Replace Comma with Period in Excel Picture 5

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

Change number separator

How to Replace Comma with Period in Excel Picture 6

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.

How to Replace Comma with Period in Excel Picture 7

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.

How to Replace Comma with Period in Excel Picture 8

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.

How to Replace Comma with Period in Excel Picture 9

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.

How to Replace Comma with Period in Excel Picture 10

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.

How to Replace Comma with Period in Excel Picture 11

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.

David Pac

Update 21 February 2022