How to Convert Numbers to Text Format in Excel? Easy Tutorial!!
Tags: excelbasics, excelpreface, exceltutorials, convertnumberstotext
Published: 2021-01-18 03:57:09

---
title: How to Convert Numbers to Text Format in Excel? Easy Tutorial!!
published: true
date: 2021-01-11 03:57:31 UTC
tags: ExcelBasics,ExcelPreface,ExcelTutorials,convertnumberstotext
canonical_url: https://geekexcel.com/convert-numbers-to-text-format/
---

Assuming that you want to display leading zero in numbers in the cell, then you need to convert them into Text based on the specified Format text. This post will guide you on how to **convert numbers to text with the Excel TEXT function**. Let’s get 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)
## Text Function:

- The **[TEXT Function](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/)** will accept a numeric value as the first argument, then convert it into the text based on the format code in the second argument.
- In Simple words, the text function converts a number to text in the given format.
- Using this function you can convert all the standard number formats such as date, times, currency to a text string in Excel.

The Syntax of the TEXT function is,

**=[TEXT](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/)(value, format\_text)**

## Steps to Convert Number to Text:

### Example 1:

- If you want to convert the numbers in the cell to Text without any formatting, then you can use the below formula.

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

- First you need to give the input number and apply the given formula.

![Enter a formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-a-formula-8.png)<figcaption id="caption-attachment-20900">Enter a formula</figcaption>

- It will convert the number to text with no special formatting. Refer to the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-19.png)<figcaption id="caption-attachment-20901">Example 1</figcaption>

### Example 2:

- When you need to **display** the **leading zero** in numbers means, you can use the below formula.

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

- The formatted text “0000” will display the text string as follows:

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Example-2-2.png)<figcaption id="caption-attachment-20903">Example 2</figcaption>

### Example 3:

- In case you want to convert the number into a text string that keeps two decimal digits, just use the below formula.

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

- This formatted text will display the number as a decimal digit values as per the below example image.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Example-3-1.png)<figcaption id="caption-attachment-20904">Example 3</figcaption>

## Excel Format Codes with Description:

The below-given table will help to know more format codes in Excel formatting. Make use of it.

| Format

Code

 | Description | Examples |
| --- | --- | --- |
| **0** | It will display the digits in their place. It can force the function to display at least two decimal places. | =**TEXT(18.3012, “$##.00”)**

Output = **$18.30**

 |
| **#** | This will display the placeholder. | 

=**TEXT(5.678, “#.##”)**

Output = **5.66**

 |
| **.** | It shows the position of the decimal point. | **=TEXT(45.4, “0.00”)**

Output = **45.40**

 |
| **d** | Represents the day of the month or day of the week. | =**TEXT(TODAY(), “dddd”)**

Output = **Monday**

 |
| **m** | It refers to the [month](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/) of the [year](https://geekexcel.com/how-to-use-year-function-in-excel-365/). | =**TEXT(TODAY(), “MM/DD/YY”)**

Output = **01/04/21**

 |
| **y** | [Year](https://geekexcel.com/how-to-use-year-function-in-excel-365/) | =**TEXT(TODAY(), “MM/DD/YY”)**

Output = **01/04/21**

 |
| **h** | [Hour](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/) is represented by one or two-digit number. | =**TEXT(15:20, “hh:mm”)**

Output = **15:20**

 |
| **m** | [Minute](https://geekexcel.com/how-to-use-minute-function-in-excel-365/) | =**TEXT(14:15, “hh:mm”)**

Output = **14:15**

 |
| **s** | [Second](https://geekexcel.com/how-to-use-second-function-in-microsoft-excel-365/) | Nil |

## Conclusion:

In this short article, you can easily learn the instructions to **convert numbers to text with the Excel**  using TEXT Function. If you have any **queries/suggestions,** kindly drop it in the below comment box. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!

### Read Ahead:

- [**Convert Date to Month & Year Only in Excel Office 365!!**](https://geekexcel.com/convert-date-to-month-year-only-in-excel-office-365/)
- **[Use Find & Replace Tool to Replace Text in Excel Office 365!!](https://geekexcel.com/use-find-replace-tool-to-replace-text-in-excel-office-365/)**