Thứ Sáu, Tháng Hai 7, 2025
spot_img
HomeFinance3 ways to separate thousands with commas in Excel

3 ways to separate thousands with commas in Excel

To separate thousands with commas in Excel, we have 3 very simple ways to do it. We can change the comma position to separate units in a number range or set the default type of separation in the Excel table. The article below will show you how to use commas to separate thousands in Excel. All of the methods below apply to all versions of Excel from Excel 2007 to Excel 2019.

1. Separate thousands in Excel using the decimal button

This first method will be suitable for quickly changing a specific cell. Then you just need to click on the decimal button icon to use.

Click on the data that needs to create a decimal point or highlight the data area that needs to be changed, then click Decimal button icon as shown below. Each time you click on this decimal symbol, the number automatically changes.

Decimal button icon

2. Separate thousands in Excel via Excel Options

To fix the thousands separator in Excel in each data table without having to manually adjust the style, we will set it up from the settings section in Excel.

Step 1:

At Excel you Click on File then click next Options section below.

Click Options Excel

Step 2:

Switch to the Excel settings interface, click on it Advanced section on the left edge of the interface. Then go to the right to find it Editing Options setting group. Find options Automatically Insert a Decimal Point and select to use.

You will Fill in the decimal point position displayed in the number range Go to the Places box below.

Xem thêm  How to install Christmas theme for Messenger

Set Excel separator

After setting up, click OK below to save this new setting. So when you work on Excel in any spreadsheet, the decimal numbers are automatically separated by commas at the position we have set.

3. Separate thousands in Excel using Format Cells

Step 1:

First Highlight data columns Need format to display commas separating thousands or hundreds depending on the number range in the data table. Then right click on the table and select Format Cells… in the drop-down list.

Click to select Format Cells

Step 2:

After the Fomat Cells dialog box appears, we click to select it Number tab then select continue Number section. Part Decimal places we set is 3. Check the item Use 1000 Separator (,) then press OK.

Customize Numbers in Excel

As a result, the user will receive a data table as shown below. The data will be separated by units.

Separate thousands by commas

An extremely simple trick to display commas separating rows in a series of numbers in Excel. Thus, the data table on Excel will be clearer, helping to read data more accurately and quickly.

Wishing you success!

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments