In Excel, there are different forms of data: text and numbers are two of them. Text data is aligned to the left side of an Excel Cell, while numeric data is aligned to the right side of an Excel Cell. In an Excel Worksheet, the text is mainly used for headers, names, descriptions, titles, comments, and so on. However, we may need to display numbers in a distinct format or combine numbers with text or symbols. So, we will demonstrate three simple functions to convert number to text with commas in excel.

**๐ Download Excel File**

You can download the Excel file used for the demonstration from the link below.

## Convert Number to Text with Commas in Excel with These 3 Methods

Firstly, let us get acquainted with our dataset used throughout the article as an example. We have the population of some cities in number format, and we want to view the population in text format with commas. This spreadsheet contains three columns, cities and their population in the first two, and in the third column, we will have the populations with commas after applying functions. Hence, we will use this dataset to demonstrate 3 simple functions to convert number to text with commas in Excel.

**Method 1**

### 1. Using **TEXT** Function

**The TEXT function** converts a number to text by applying formatting with format codes. In this method, we will use the **TEXT** function to convert numbers to text with commas in Excel. Let us go through the steps to apply this function.

**โฌ๏ธโฌ๏ธ STEPS โฌ๏ธโฌ๏ธ**

- First, select the cell where you want the desired result. Here, we are selecting cell
**D6**.

- Next, insert the formula.

**=TEXT(C6,โ#,#โ)**

**C6**contains the value we want to format, and

**โ#,#โ**shows that we want a number in text format with commas.

- After inserting, press
**Enter**.

- Then copy and paste this formula into all other cells where you want to calculate overdue days. For that, select cell
**D6**again and click & drag the**Fill Handle**down, or**Double-click**on the plus that appeared to**Autofill**the cells after selecting.

- Lastly, the outcome looks like this.

**Method 2**

### 2. Employing FIXED Function

In this second method, we will use **the FIXED function**. A fixed function typically rounds a number to the specified number of decimals, formats the number in decimal format with a period and commas, and returns the result as text. So, let us see the steps to apply this function,

**โฌ๏ธโฌ๏ธ STEPS โฌ๏ธโฌ๏ธ**

- First, select cell
**D6**.

- Then insert the formula.

**=FIXED(C6,0,)**

**C6.**Now,

**decimals**input is optional and shows the digits to the right of decimals. Since we do not want decimals, we put

**0**here. Lastly,

**no commas**are also optional and a logical value that, if

**TRUE**, prevents the

**FIXED**function from including commas in the returned text, which in our case is

**FALSE**.

- After that, press
**Enter**.

- Lastly, copy and paste this formula by dragging the
**Fill Handle**down or**Double-click**on the plus that appeared to**Autofill**the cells after selecting.

**๐ Read More: How to Convert Number to Text with 2 Decimal Places in Excel**

**Method 3**

### 3. Applying DOLLAR Function

Now, we will apply **the DOLLAR function** to convert numbers into text. Since the **DOLLAR** function converts a number to text using currency format, with the decimals rounded to the number of places specified, we are using a new dataset containing **Product** Name and their corresponding **Prices**.

Let us see the steps now.

**โฌ๏ธโฌ๏ธ STEPS โฌ๏ธโฌ๏ธ**

- At first, select cell
**D6**.

- After that, insert the formula.

**=DOLLAR(C6,0)**

**C6**contains the number, and

**0**shows that we do not want any decimal points.

- Then, press
**Enter**.

- Finally, copy and paste this formula into all other cells where you want to convert the number to text. For that, select cell
**D6**again and click & drag the**Fill Handle**down, or**Double-click**on the plus that appeared to**Autofill**the cells after selecting.

## ๐ Important Notes

`๐๏ธ`

ย In Microsoft Excel, numbers can never have more than 15 significant digits. However, in Text format, we can enter as many digits as we want.

`๐๏ธ`

ย If no commas are set to **FALSE **or omitted, the returned text contains commas as usual.

## ๐ Takeaways from This Article

`๐`

ย This article demonstrated three functions to convert a number to text with commas in excel.

`๐`

ย In the first method, we showed the **TEXT **function to convert the number to text with commas in excel.

`๐`

ย Then, we demonstrated a function that applies a **FIXED **function to perform the conversion of numbers to text in excel.

`๐`

ย Finally, we employed the **DOLLAR **function to convert numbers to text.

## Conclusion

This article has demonstrated three functions to convert any number to text with commas in excel. All these formulas are incredibly effective and simple to use. We hope this article helps you. Please leave a remark if you have any queries. The author will do their best to find an appropriate answer.

For more guides like this, visit **Excelden.com**.

## Related Articles

**6 Easy Tricks to Convert Date to Text (YYYYMMDD) in Excel****4 Ways to Convert Number to Text and Keep Trailing Zeros in Excel****How to Convert Number to Text with Leading Zeros in Excel**