# How to Add the Thousands Separator to an Excel Formula

## This is an overview.

### Step 1 – Creating a Dataset

• Insert a new column to add the thousands separator in an Excel formula.

### Step 2 – Applying the TEXT Function

• Use the TEXT function which has two arguments: in the value argument, enter a value. In the format_text argument, choose a format.

The general syntax for the TEXT function is:

`=TEXT(value,format_text)`

### Step 3 – Inserting the Value Argument

• Enter the value argument in E5.

### Step 4 – Inserting the Format_text Argument

• Enter the format_text argument.
• E5 represents the value, and “#,####” displays the thousands separator with no decimal places.

### Step 5 – Final Results

#### 5.1 Thousands Separator Without Decimal Value

• Click F5 to display the thousands separator.
•  “#,####” displays a thousand separator with no decimal places.

• This is the output.

• Drag down the Fill Handle to see the result in the rest of the cells.

#### 5.2 Thousands Separator with Decimal Value

• Select F5 to display the thousands separator.
• ” #,###.00″ displays a thousand separator with two decimal places.

This is the output.

• Drag down the Fill Handle to see the result in the rest of the cells.

## Related Articles

<< Go Back to How to Add Comma in Excel | Concatenate Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF