How to Convert Commas to Periods in Microsoft Excel: 11 Steps

Table of contents:

How to Convert Commas to Periods in Microsoft Excel: 11 Steps
How to Convert Commas to Periods in Microsoft Excel: 11 Steps

Video: How to Convert Commas to Periods in Microsoft Excel: 11 Steps

Video: How to Convert Commas to Periods in Microsoft Excel: 11 Steps
Video: How to Run Flash Files After (12 Jan 2021) - Adobe Flash Player 2024, November
Anonim

This wikiHow teaches you how to convert commas to periods in Microsoft Excel. Replacing commas with periods manually in Excel certainly takes a lot of time. You may have to make changes because Indonesia uses commas as decimal separators instead of periods. Fortunately, this problem can be handled fairly easily.

Step

Method 1 of 2: Using the Find & Select Tool

Change a Comma to Dot in Excel Step 1
Change a Comma to Dot in Excel Step 1

Step 1. Open the Excel spreadsheet that you need to update

Locate the spreadsheet file, either on the desktop or in a folder and double-click the file to open it.

Change a Comma to Dot in Excel Step 2
Change a Comma to Dot in Excel Step 2

Step 2. Click the Find & Select button

It's in the upper-right corner of the screen. Additionally, the button has “Find & Select” and is indicated by a magnifying glass or binocular icon, depending on the version of Excel you are using.

Change a Comma to Dot in Excel Step 3
Change a Comma to Dot in Excel Step 3

Step 3. Click Replace from the menu

After that, the menu will be displayed and “ Replace ” is second to the bottom, just to the left of the arrow icon between the letters “b” and “c”.

Change a Comma to Dot in Excel Step 4
Change a Comma to Dot in Excel Step 4

Step 4. Fill in the fields

A new window will open and display two columns, “Find what” and “Replace with”. In the "Find what" field, type a comma. In the “Replace with” field, type a period.

Change a Comma to Dot in Excel Step 5
Change a Comma to Dot in Excel Step 5

Step 5. Click Replace All

Once the option is clicked, every comma in the document will be converted to a period.

Method 2 of 2: Changing the Number Separator

Change a Comma to Dot in Excel Step 6
Change a Comma to Dot in Excel Step 6

Step 1. Open the Excel spreadsheet that you need to update

Locate the spreadsheet file, either on the desktop or in a folder and double-click the file to open it.

Change a Comma to Dot in Excel Step 7
Change a Comma to Dot in Excel Step 7

Step 2. Click File in the upper-left corner of the window

Knob File ” is always the first option on the menu at the top of a Microsoft Office document. You'll find it in the upper-left corner of the program window.

Change a Comma to Dot in Excel Step 8
Change a Comma to Dot in Excel Step 8

Step 3. Click Options in the lower left corner

The menu on the left side of the screen is marked in green. At the bottom of the menu, in the lower left corner of the menu, you can see the option “ Options ”.

Change a Comma to Dot in Excel Step 9
Change a Comma to Dot in Excel Step 9

Step 4. Click Advanced on the menu on the left side

The “Excel Options” window will appear and load another menu on its left side. You can find the option “ Advanced " under " Ease of Access ”.

Change a Comma to Dot in Excel Step 10
Change a Comma to Dot in Excel Step 10

Step 5. Uncheck the Use system separators box

You can see this option under the “ Editing options Automatically, the box is already ticked. Click the check to remove it so the box becomes empty.

Change a Comma to Dot in Excel Step 11
Change a Comma to Dot in Excel Step 11

Step 6. Update the Decimal separator column and Thousands separator as needed.

One of the columns will display a comma, depending on the default/main program settings. Replace the comma with a period and click “OK” at the bottom of the window to complete the changes.

Recommended: