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!

4.3 ★ | 4 Vote

May be interested

  • How to merge multiple sheets into 1 PDF file in Excel 2013Photo of How to merge multiple sheets into 1 PDF file in Excel 2013
    when using office 2007 version and below when you want to convert into a pdf file, you add add-on but now with office 2013 with just a few simple steps, you can combine multiple sheets in excel into one pdf file.
  • How to insert math formulas in ExcelPhoto of How to insert math formulas in Excel
    in the learning process, you often use ms excel to calculate and process data. because of some requirements that you need to insert mathematical formulas into excel, but you do not know how to manipulate.
  • Instructions to use the Replace feature to reverse position words in WordPhoto of Instructions to use the Replace feature to reverse position words in Word
    the replace feature in word you often know for the word substitution function commonly used to search and replace words in word. but in addition to the functions that you often use, replace also helps you reverse the position of words in word.
  • ISNA function in ExcelPhoto of ISNA function in Excel
    using excel documents shared from friends or on the internet, you sometimes come across isna () combined with other functions like vlookup () and if (). you wonder why they use isna () function so?
  • Instructions on how to draw organizational structure diagram in WordPhoto of Instructions on how to draw organizational structure diagram in Word
    to draw an organization chart in word you can use one of two ways: using smartart and using the shapes tool. using smartart will help you draw an organization chart faster than using the shapes tool.
  • How to write vertically, rotate text vertically in WordPhoto of How to write vertically, rotate text vertically in Word
    according to some requirements, you need to write vertical letters in word, but you do not know how to write vertical letters? to be able to write vertically in word, there are many ways, you can refer to the ways guided in this article.