Excel Formulas to Covert Numbers into Text ~ A Complete Guide!!
Tags: excelformula, excelformulas
Published: 2021-06-16 02:56:28

---
title: Excel Formulas to Covert Numbers into Text ~ A Complete Guide!!
published: true
date: 2021-06-03 16:01:50 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-covert-numbers-into-text-a-complete-guide/
---

In the previous post, we have seen how to**[convert the text to numbers](https://geekexcel.com/excel-formulas-into-convert-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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Convert numbers into text](https://geekexcel.com/wp-content/uploads/2021/06/Convert-numbers-into-text.png)](https://geekexcel.com/excel-formulas-to-covert-numbers-into-text-a-complete-guide/convert-numbers-into-text/#main)<figcaption id="caption-attachment-46019">Convert numbers into text</figcaption>

## Generic Formula:

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

**=[TEXT](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/)(A1,”0″)**

## Syntax Explanations:

- **TEXT** – This function helps to convert a number to text in the given format. Read more on the [**TEXT function**](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/).
- **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.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-6.png)<figcaption id="caption-attachment-46021">Input Ranges</figcaption>

- Select any cell and apply the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-9.png)<figcaption id="caption-attachment-46020">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-8.png)<figcaption id="caption-attachment-46018">Result</figcaption>

## 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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[How to Search for a Value in All Tabs in Excel Office 365?](https://geekexcel.com/how-to-search-for-a-value-in-all-tabs-in-excel-office-365/)**
- **[Excel Formulas Check the Cell Contains Some Words but Not Others!!](https://geekexcel.com/excel-formulas-check-the-cell-contains-some-words-but-not-others/)**
- **[Excel Formulas to Add a Line Break ~ A Complete Tutorial!!](https://geekexcel.com/excel-formulas-to-add-a-line-break/)**
- **[How to Count missing values in a list in Excel Office 365?](https://geekexcel.com/how-to-count-missing-values-in-a-list-in-excel-office-365/)**