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!

Marvin Fry

Update 19 May 2020

You should read it

May be interested

How to separate text strings by commas or spaces in Excel
separating text strings based on commas or spaces is a trick that helps you split the characters in a parameter cell into different clusters based on commas or spaces that parameter cell contains. tipsmake will guide you how to separate text strings by commas or spaces in excel.
How to display thousands separator commas in Excel
how to display thousands separator commas in excel - you often have to work with excel, enter data for excel and calculate, process them.
How to convert Excel files to CSV
the csv file is a plain text format file in which the values will be separated by commas. it is often used to save small-scale spreadsheets such as contacts, class lists, reports, etc.
Instructions for rounding decimal numbers after commas in Excel
the round function in excel helps you round down decimal numbers into natural numbers without commas. so, how do you want to round decimal places after commas?
Create dots in Word, how to create dots lines, tab line dots (.........) in Word
create dots in word, how to create dots lines, tab line dots (.........) in word. students writing essays, projects, or paper forms will often have dotted lines to fill in the content. if you often have to draft these documents, you cannot enter them
Change the slash to a dot in Excel format
by default, the excel date format often uses slashes, such as march 23, 2016 .... however, if your worksheet has multiple dates lists, you can use dots. in date format to make the worksheet easier to see, no glitches.
Simple way to convert Excel files to PDF - Convert directly or use software
converting excel files to pdf will help create more professional documents, preventing spreadsheets from being modified during the exchange process. so how to convert excel to pdf?
How to convert Excel files to PDF online using Google Drive
if you often use microsoft office excel to share with colleagues, friends, there will probably be cases where you want to send excel files in pdf format.
How to convert CSV files to Excel in bulk
with just a few simple operations, we can batch transfer csv files to excel.
How to convert money into words in Excel, without an add-in, supports both 32-bit and 64-bit Excel
convert numbers into words in excel, convert amounts into words with excel versions from 2003 to 2016, excel free like wps office, no need to install add-ins, support both 32-bit and 64-bit versions.

How to convert dots to commas in Excel on Windows 7

You should read it

May be interested

Office information