Excel Formulas to Covert Numbers into Text ~ A Complete Guide!!

In the previous post, we have seen how to*convert the text to numbers. Likewise, here we are going to learn the simple formulas to **convert the numbers into text format in Excel. Let’s jump into this article!! Get an official version of * MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

You can use the below formula to convert the numerical values into the text format.

=TEXT(A1,”0″)

Syntax Explanations:

TEXT – This function helps to convert a number to text in the given format. Read more on the TEXT function.

A1 – It represents the input value.

Comma symbol (,) – It is a separator that helps to separate a list of values.

Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Let’s consider the below example image.

Here, we will enter the input values in Column B.

Now we need to change the numbers into text format.

Select any cell and apply the above-given formula.

Finally, press ENTER to get the result out.

Conclusion:

From this guide, you can get some clarification on how to convert numbers into text in Excel. Please share your query below in the comment box. We will assist you.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

How to Search for a Value in All Tabs in Excel Office 365?

Excel Formulas Check the Cell Contains Some Words but Not Others!!

Excel Formulas to Add a Line Break ~ A Complete Tutorial!!

How to Count missing values in a list in Excel Office 365?