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 .
Step 2: The Control Panel dialog box appears -> select Region and Language .
Step 3: The Region and Language dialog box appears, click on Additional Settings .
Step 4: In the Decimal Symbol section enter a comma, the Didit Grouping Symbol section enter a period -> click OK to complete.
Step 5: Open the Excel file, enter the number and check.
All values containing periods are replaced by commas. Good luck!
4.3 ★ | 4 Vote
You should read it
- 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
May be interested
- How to merge multiple sheets into 1 PDF file in Excel 2013when 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 Excelin 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 Wordthe 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 Excelusing 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 Wordto 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 Wordaccording 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.