How to Convert Commas to Dots in Excel - Convert Unit

This practical guide walks through how to convert Commas to Dots in Excel - Convert Unit. It organizes the required steps, settings, and checks so you can complete the task with fewer mistakes.

When entering data in Excel, with number format, Excel will automatically separate by dots or commas. Thus, the units of data will be separated more clearly. you can use periods or commas to separate units in the number sequence. However, if in a document the units separator mark is not consistent, you need to switch back to the same type of mark. this guide explains how to convert commas to periods or vice versa in Excel.

Instructions for Converting Commas to Dots in Excel

In this data table, commas are used to separate units in Excel. That requirement is to convert commas to dots separating units.

Step 1:

At the Excel interface, we select The Office icon And then choose Excel Options .

Step 2:

Switch to the new interface, select Advanced Then look to the right of the Use system separators section, uncheck the box . Then you fill in the dots in Decimal separator As decimal numbers and Thousands separator As thousands numbers. choose OK to save the changes.

Immediately after that, the comma separating the number units in Excel was converted to a period.

In addition, we can use dots for decimal separators and commas for thousands separators, depending on the user's needs.

On Excel 2003 , the implementation will be different. At the interface, select The Tools tab And then choose Options .

Then switch to the new interface, select International And Uncheck the Use system separators section . Finally, you also change the values for Decimal separator as decimal numbers and Thousands separator as thousands numbers for each other and confirm OK.

Basically, the operation to change periods to commas in Excel is the same for all versions. You also need to turn off the system's automatic separation setting and then adjust it under your needs. We can use the same type of separator or 2 types of separators at the same time.