3 Ways to Convert Number to Text with Commas in Excel

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.

Contents hide

📁 Download Excel File

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

1. Using TEXT Function

2. Employing FIXED Function

3. Applying DOLLAR Function

📄 Important Notes

📝 Takeaways from This Article

Conclusion

📁 Download Excel File

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

Convert Number to Text with Commas.xlsx

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,”#,#”)

Here, cell 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,)

Here, the first input is the number to round and convert to text in cell 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.

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)

Here, cell 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.

(Visited 146 times, 1 visits today)