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