How to separate thousands by commas in Excel

The decimal number on Excel will help us separate thousands, hundreds, ... units when entering the calculation number or with the currency in the data table.

The data when imported into Excel, especially the numbers in the calculation or currency unit if there is a comma that separates the rows of the number will be easy for the viewer, as well as the person handling the spreadsheet.

However, when the data entered into Excel will not normally display comma delimited, the numbers will stick together causing difficulties in reading the data sheet as well as processing the exact value, time-consuming of the person. use. When entering data into Excel if multiple rows, classes, the use of dots or commas separating units, axes, hundreds, . is necessary to avoid confusion. So how to display comma separating thousands on Excel?

  1. These are the most basic functions in Excel that you need to understand
  2. Summary of expensive shortcuts in Microsoft Excel

Below is an example table where we will display a comma to divide the units in the sequence.

Picture 1 of How to separate thousands by commas in Excel

Step 1:

First black out the data columns need to format comma separating thousands, or hundreds depending on the number in the data table. Then right-click on the table and select Format Cells . in the drop-down list.

Picture 2 of How to separate thousands by commas in Excel

Step 2:

After the Fomat Cells dialog interface appears, we click on the Number tab and then select the Number item . The Decimal places section we set is 3 . Select the item in Use 1000 Separator (,) and then click OK .

Picture 3 of How to separate thousands by commas in Excel

The result will be user data table as shown below. The data will be separated by unit rows.

Picture 4 of How to separate thousands by commas in Excel

An extremely simple trick to display commas that separates rows in an Excel number. Therefore, the data sheet in Excel will be clearer, making reading data more accurate and quicker.

I wish you all success!

Update 25 May 2019
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile