How to convert commas to dots in Excel - Convert unit separator

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. Users 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. The article below will guide you 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.

How to convert commas to dots in Excel - Convert unit separator Picture 1

Step 1:

At the Excel interface, we click on the Office icon and then select Excel Options .

How to convert commas to dots in Excel - Convert unit separator Picture 2

Step 2:

Switch to the new interface, click on 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. Click OK to save.

How to convert commas to dots in Excel - Convert unit separator Picture 3

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

How to convert commas to dots in Excel - Convert unit separator Picture 4

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, click on the Tools tab and then select Options .

How to convert commas to dots in Excel - Convert unit separator Picture 5

Then switch to the new interface, click on 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.

How to convert commas to dots in Excel - Convert unit separator Picture 6

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 according to your needs. We can use the same type of separator or 2 types of separators at the same time.

David Pac

Update 10 June 2024