How to convert commas into dots in Excel

In Excel, to separate units in a metric, we can use dots or commas. So how to convert the dot to a comma or vice versa?

When entering data in Excel, in digital format, Excel will automatically be separated by dots or commas. Thus, the units of the data will be more clearly separated. Users can use dots, or commas to separate units in the sequence. However, if in a document the unit line separator is not uniform, you need to switch back to the same type of sign. The following article will guide you how to convert commas into dots or vice versa on Excel.

  1. Change the slash to a dot in Excel format
  2. How to separate thousands by commas in Excel
  3. Create a quick dot (……………) line in Microsoft Word

Instructions to convert commas into Excel dots

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

How to convert commas into dots in Excel Picture 1How to convert commas into dots in Excel Picture 1

Step 1:

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

How to convert commas into dots in Excel Picture 2How to convert commas into dots in Excel Picture 2

Step 2:

Switch to the new interface you click on Advanced then look to the right of the Use system separators section, uncheck the check box . Then you fill the dots on the Decimal separator as the decimal number and Thousands separator is the number of thousands. Click OK to save.

How to convert commas into dots in Excel Picture 3How to convert commas into dots in Excel Picture 3

Soon comma separates the number units on Excel that have been converted to dots.

How to convert commas into dots in Excel Picture 4How to convert commas into dots in Excel Picture 4

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

In Excel 2003 , the implementation will be different. At the interface click on the Tools tab and select Options .

How to convert commas into dots in Excel Picture 5How to convert commas into dots in Excel Picture 5

Then switch to the new interface and click on International and uncheck the Use system separators section . Finally you change the value for the Decimal separator as the decimal numbers and Thousands separator is the thousands of numbers for each other then confirm OK.

How to convert commas into dots in Excel Picture 6How to convert commas into dots in Excel Picture 6

Basically, the operation to change the dot to a comma on Excel with the versions is the same, you also need to remove the automatic separation of the system and then adjust it according to your needs We can use the same type of separator or two types of markers at the same time.

See more:

  1. Invaluable Word shortcuts when processing text
  2. These are the most basic functions in Excel that you need to understand
  3. Summary of expensive shortcuts in Microsoft Excel

I wish you all success!

3.8 ★ | 11 Vote