How to convert commas to dots in Excel

According to conventional units of the United States and Britain and some European countries, the dot separates decimal numbers, such as 0.01. There are commas to divide thousands and millions, for example 1,500,000 was 1 million 500 thousand. As for Vietnam and some Asian countries, the convention is the opposite. Therefore, you need to convert commas to dots in Excel to easily see the parameters, especially when reading the statements, payrolls with figures, amounts, the mistake should not occur. In the previous article, Taimienphi instructed to convert dots to commas in Excel and received a lot of positive feedback, but in this article, on the contrary, we will guide you how to convert commas into dots .

Instructions to convert commas to dots in Excel

How to convert commas to dots in Excel 2019, 2016, 2013, 2010, 2007, 2003

Turn commas into dots in Excel 2019, 2016, 2013

Because all versions of Excel 2019, 2016, 2013 have the same interface, the comma-to-dot feature in Excel is exactly the same.
Step 1: First, open any Excel file and then go to the section File on the menu bar of Excel.

Step 2: On the next screen interface, scroll down to the bottom where available Options. Click on it to access Excel Options.

Step 3: In Excel Options users only need to access the section Advanced, in this section, you will see a section Use system separators The default is to be used by the system. To edit converting commas to dots in Excel we need to turn this section off.

There are 2 values ​​here Decimal separator and Thousands separator all you need to do is convert the dot and comma positions to each other. Thus we have converted commas into dots in Excel 2019, 2016, 2013
Convert commas to dots in Excel 2010 and 2007
The versions of Excel 2010 and 2007 have a lot in common, especially the function of converting commas to dots in Excel is exactly the same, so Taimienphi.vn will guide one version and apply it to both.
Step 1: First we still need to open any Excel file, in this we just need to click File on the menu bar.

Step 2: In the File folder we choose Continue to Options section > Here you choose Options same as above.

Step 3: In Excel Options we access the next section Advanced Options and scroll down to uncheck the box Use system separators then change the position of the colon and the comma.

Convert commas to dots in Excel 2003

Step 1: In the interface using Excel, you click the application icon in the left corner and select Excel Options as shown below

Step 2: The Excel Options interface opens, click on the item Advanced.

Step 3: Attention section User system seprators. Let’s uncheck the box This can be used to convert commas to dots in Excel.

Step 4: Here you pay attention Thousand seprator is (,) Commas are being used to divide the units of thousands and millions. Please turn it into sign (.) Dot.

Part Decimal Seprator can change words sign (.) to (,) comma or leave it intact. Press OK, got it to save the operation.

You will get a new digital interface that’s easier to distinguish. But still should change Decimal Seprator to comma to distinguish the decimal and the easiest thousands.

The above guide has helped you convert commas into dots in Excel successfully. If you have any questions, please comment below for Taimienphi.vn to help you answer, in addition to changing the dot to a comma is also available on Thuthuat.taimienphi.vn, readers can find and follow. Along with converting commas to dots, the user encountered a date error that is reversed in Excel quite a lot and if you are in this situation, the article on how to fix date is reversed in Excel first. That we share will help you overcome thoroughly.

Using Excel, you must have printed Excel yourself by the printer, right, the printing of excel is more difficult than printing word documents, so please refer to how to print Excel on taimienphi.vn to have best practices.

The latest version is Excel 2016, download Excel here: Download Excel 2016

https://thuthuat.taimienphi.vn/cach-chuyen-dau-ayay-thanh-dau-cham-trong-excel-24773n.aspx
Using the 2016 version of Excel, users should learn about features on Office 2016 that users don’t know. Master these Features on Office 2016 This little user, you will work best with Excel. Especially when Office 2016 tools have a lot of new and attractive features worth using. Download Office 2016 you also have Word 2016 tools, Power Point 2016 customizable interface, much easier to use.