You are viewing the article How to Replace Comma with Period in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 4,900 times.
This is an article on how to replace commas with periods in Excel. Manually replacing commas with periods in Excel can be very time consuming. You will encounter this situation because European countries use comma as decimal separator instead of period. Fortunately, changing the sign is very simple.
Steps
Using the Find & Select tool
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/73/Change-a-Comma-to-Dot-in-Excel-Step-1.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/73/Change-a-Comma-to- Dot-in-Excel-Step-1.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-1.jpg”,”smallWidth”:460,”smallHeight”:346,” bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Excel worksheet that needs updating. Find the file saved on the home screen or in a certain folder, and double-click to open it.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/70/Change-a-Comma-to-Dot-in-Excel-Step-2.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/70/Change-a-Comma-to- Dot-in-Excel-Step-2.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-2.jpg”,”smallWidth”:460,”smallHeight”:346,” bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}
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.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a3/Change-a-Comma-to-Dot-in-Excel-Step-3.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a3/Change-a-Comma-to- Dot-in-Excel-Step-3.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-3.jpg”,”smallWidth”:460,”smallHeight”:346,” bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser-output”></div>”}
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.”
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/40/Change-a-Comma-to-Dot-in-Excel-Step-4.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/40/Change-a-Comma-to- Dot-in-Excel-Step-4.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
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 enter a period in the “Replace with” field.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c2/Change-a-Comma-to-Dot-in-Excel-Step-5.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c2/Change-a-Comma-to- Dot-in-Excel-Step-5.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-5.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Replace All . Clicking this option will replace all commas in the document with periods.
Change number separator
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c3/Change-a-Comma-to-Dot-in-Excel-Step-6.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c3/Change-a-Comma-to- Dot-in-Excel-Step-6.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-6.jpg”,”smallWidth”:460,”smallHeight”:346,” bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Excel worksheet that needs updating. Find the file saved on the home screen or in a certain folder, and double-click to open it.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cc/Change-a-Comma-to-Dot-in-Excel-Step-7.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cc/Change-a-Comma-to- Dot-in-Excel-Step-7.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-7.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
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.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/bd/Change-a-Comma-to-Dot-in-Excel-Step-8.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/bd/Change-a-Comma-to- Dot-in-Excel-Step-8.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-8.jpg”,”smallWidth”:460,”smallHeight”:347,” bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}
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.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c4/Change-a-Comma-to-Dot-in-Excel-Step-9.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c4/Change-a-Comma-to- Dot-in-Excel-Step-9.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-9.jpg”,”smallWidth”:460,”smallHeight”:346,” bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Advanced in the left menu. The Excel Options window displays with another menu on the left. You can find the Advanced option right under Ease of Access .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1c/Change-a-Comma-to-Dot-in-Excel-Step-10.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1c/Change-a-Comma-to- Dot-in-Excel-Step-10.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-10.jpg”,”smallWidth”:460,”smallHeight”:346,” bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser-output”></div>”}
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 checkmark by clicking on it and the cell will be deselected.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b9/Change-a-Comma-to-Dot-in-Excel-Step-11.jpg/v4-728px-Change- a-Comma-to-Dot-in-Excel-Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b9/Change-a-Comma-to- Dot-in-Excel-Step-11.jpg/v4-728px-Change-a-Comma-to-Dot-in-Excel-Step-11.jpg”,”smallWidth”:460,”smallHeight”:343,” bigWidth”:728,”bigHeight”:543,”licensing”:”<div class=”mw-parser-output”></div>”}
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.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 4,900 times.
This is an article on how to replace commas with periods in Excel. Manually replacing commas with periods in Excel can be very time consuming. You will encounter this situation because European countries use comma as decimal separator instead of period. Fortunately, changing the sign is very simple.
Thank you for reading this post How to Replace Comma with Period in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: