How to convert commas to dots in Excel


In Excel, users are allowed to customize to convert commas into dots in Excel depending on the region and country of use. The comma-to-dot feature in Excel applies to all versions that users can easily set up in Excel Options. The following tutorial will help you how to convert commas to dots in Excel 2019, 2016, 2013, 2010, 2007 and 2003


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.
how to turn a scratch bar in excel
Step 2: On the next screen interface, scroll down to the bottom where available Options. Click on it to access Excel Options.
how to turn a scratch bar in excel
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.
how to turn a scratch bar in excel
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.
how to turn a scratch bar in excel
Step 2: In the File folder we choose Continue to Options section > Here you choose Options same as above.
how to turn a scratch bar in excel
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.
how to turn a scratch bar in excel

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

how to convert scratch bar in excel 2

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

how to convert scratch bar in excel 3

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

how to convert scratch bar in excel 4

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.

how to convert scratch bar in excel 5

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

how to turn a scratch bar in excel 6

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.

how to convert scratch bar in excel 7

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.

.

Add a Comment

Your email address will not be published. Required fields are marked *