Home Application Office information

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.

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 .

Picture 1 of How to convert dots to commas in Excel on Windows 7

Step 2: The Control Panel dialog box appears -> select Region and Language .

Picture 2 of How to convert dots to commas in Excel on Windows 7

Step 3: The Region and Language dialog box appears, click on Additional Settings .

Picture 3 of How to convert dots to commas in Excel on Windows 7

Step 4: In the Decimal Symbol section enter a comma, the Didit Grouping Symbol section enter a period -> click OK to complete.

Picture 4 of How to convert dots to commas in Excel on Windows 7

Step 5: Open the Excel file, enter the number and check.

Picture 5 of How to convert dots to commas in Excel on Windows 7

All values ​​containing periods are replaced by commas. Good luck!

You've just finished reading the article "How to convert dots to commas in Excel on Windows 7" edited by the TipsMake team. You can save how-to-convert-dots-to-commas-in-excel-on-windows-7.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV : How to merge...
How to fix font... : NEXT »
Read more