How to convert dots to commas in Excel on Windows 7
How to convert a dot to a comma in Excel on Windows 7. Sometimes at work you want to display the numbers in the traditional form of Vietnam: separate thousands . with commas. The following article shows How to convert dots to commas in Excel on Windows 7.
Step 1: Click Start -> Control Panel .
How to convert dots to commas in Excel on Windows 7 Picture 1
Step 2: The Control Panel dialog box appears -> select Region and Language .
How to convert dots to commas in Excel on Windows 7 Picture 2
Step 3: The Region and Language dialog box appears, click on Additional Settings .
How to convert dots to commas in Excel on Windows 7 Picture 3
Step 4: In the Decimal Symbol section enter a comma, the Didit Grouping Symbol section enter a period -> click OK to complete.
How to convert dots to commas in Excel on Windows 7 Picture 4
Step 5: Open the Excel file, enter the number and check.
How to convert dots to commas in Excel on Windows 7 Picture 5
All values containing periods are replaced by commas. Good luck!
You should read it
- Convert commas to dots in Excel
- How to convert commas into dots in Excel
- 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 merge multiple sheets into 1 PDF file in Excel 2013
How to insert math formulas in Excel
Instructions to use the Replace feature to reverse position words in Word
ISNA function in Excel
Instructions on how to draw organizational structure diagram in Word
How to write vertically, rotate text vertically in Word