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.


๐Ÿ“ 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.

Convert number to text with commas


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.

Text function-convert numbers to text with commas in excel

  • Next, insert the formula.

=TEXT(C6,โ€#,#โ€)

Enter formula-convert numbers to text with commas in excel

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.

Copy formula-convert numbers to text with commas in excel

  • Lastly, the outcome looks like this.

converted into text-convert numbers to text with commas in excel


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.

Fixed function-convert numbers to text with commas in excel

  • 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.

๐Ÿ“• 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.

Dollar function-convert numbers to text with commas in excel

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.


Related Articles

(Visited 98 times, 1 visits today)
Priti

Priti

Hello! Welcome to my Profile. I am Priti. I'm now working and researching Microsoft Excel, and I'll share articles on it here. I am passionate about problem-solving, and I hope these articles will help you. Please leave a remark if you have any queries, and I will do my best to find an appropriate answer.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo