Convert commas to dots in Excel
By default, the number format in Excel follows international standards separating thousands with commas and decimals as dots. This way of writing is in contrast to the Vietnamese writing style, so this article I will guide how to change commas into dots.
Convert commas to dots in Excel Picture 1
Therefore, the following article will guide you in detail how to convert commas to dots on Excel according to Vietnamese rules:
Step 1: On the card File -> Option:
Convert commas to dots in Excel Picture 2
Step 2: A dialog box appears, select Advanced -> Editing options, select the following:
- Uncheck the box Use system separators
- In Decimal separator: enter commas.
- In the Thousands separator: enter dots
Finally, click OK:
Convert commas to dots in Excel Picture 3
Step 3: The result has changed the comma into a dot on Exccel in accordance with the rules of Vietnamese people:
Convert commas to dots in Excel Picture 4
The above is a detailed guide on how to convert commas to dots in Excel. Good luck!
You should read it
- How to convert commas into dots in Excel
- How to convert dots to commas in Excel on Windows 7
- How to Change a Comma to Dot in Excel
- How to convert a CSV file to Excel
- How to change dots into commas on Google Sheets
- Simple way to convert Excel files to PDF
- How to get numbers after commas in Excel
- How to Replace Comma with Period in Excel
- How to separate text strings by commas or spaces in Excel
- How to display thousands separator commas in Excel
- How to convert Excel files to CSV
- Instructions for rounding decimal numbers after commas in Excel
May be interested
How to paginate pages from any page in Word 2016
How to turn off, turn on Enable Editing when opening Word, Excel
Numbering in Excel 2016
How to draw a table - Add, edit, and delete column rows in a table in Excel 2016
How to draw a table - Add, edit, and delete columns in a table in Word 2016
Instructions on how to create drop down lists or drop-down lists in Excel