We use **Excel** for various purposes, like statistical calculation, analyzing data, making reports, and so on. We can use both text and number formats in **Excel**. Sometimes, inserting numbers into Excel can cause some problems. In many cases, **Excel** will not **keep zero in the lead position in the number format.** Also, **Excel** will change the last digit to zero if the number is more than 15 digits in the number format. That’s why it is necessary to input the correct format in **Excel** according to the working purpose. In this article, we will show you how to convert number to text in **Excel**.

**Table of Contents**hide

## Download Practice Workbook

You can download the free **Excel** workbook from here and practice on your own.

## 4 Handy Ways to Convert Number to Text in Excel

We will use the following data set in this article. Here, we have a single column containing only numbers in it. In this article, we will describe four different procedures to convert number to text in **Excel**. We will apply **the TEXT function**, insert the ** Text to Columns Wizard** feature, add an apostrophe before the number, and alter the cell format for our working purpose.

### 1. Applying TEXT Function to Convert Number to Text in Excel

We can convert number to text by applying **the TEXT function** of **Excel**. You can see the following steps regarding the use of this function.

**Step 1:**

- First of all, make an extra column in column
to keep the text after converting.*C*

**Step 2:**

- Then, apply the following
**TEXT**formula in cellfor the first number.*C5*

`=TEXT(B5,"000000")`

- In this formula, in the second argument, we will input six zeroes.
- So, after converting into text it will become six-digit long.

**Step 3:**

- Finally, press
and the number*Enter*will turn into text format.*450* - Lastly, use the
feature to drag down the formula for the consecutive numbers.**AutoFill**

**Read More:** **How to Convert Numbers to Texts/Words in Excel**

### 2. Inserting Text to Columns Wizard to Convert Number to Text in Excel

Another way of converting number to text in **Excel** is to insert the ** Text to Columns Wizard** feature. Go through the following steps to know more about this feature.

**Step 1:**

- Firstly, select all the numbers that you want to convert.

**Step 2:**

- Then, go to the
tab of the ribbon.*Data* - From there, select the
command.*Text to Columns*

**Step 3:**

- Thirdly, you will see a dialogue box naming
will pop up.*Convert Text to Column Wizards – Step 1 of 3* - In the box, only press
.*Next*

- Again, you will see another dialogue box.
- In here, press
also.*Next*

- Finally, the third step of the dialogue box will appear.
- Firstly, select the
option under the*Text*heading.*Column data format* - Then, press
after fulfilling the criteria.*Finish*

**Step 4:**

- Finally, you will see that all the numbers will turn into text format.
- Their alignment will be on the left instead of the right, like in the text format in Excel.

**Read More:**** Excel VBA to Convert Number to Text (4 Examples)**

**Similar Readings**

**How to Convert Number to Text with Green Triangle in Excel****Convert Number to Words in Excel in Rupees****How to Convert Text to Numbers in Excel****Convert a Numeric Value into English Words in Excel****How to Convert Peso Number to Words in Excel (With Easy Steps)**

### 3. Adding an Apostrophe to Convert Number to Text

You can also convert a number into text format by adding an apostrophe before the number. You will get a clear idea about this after seeing the following steps.

**Step 1:**

- First of all, create an extra column for the output in text format.

**Step 2:**

- Then, type the number in the formula bar and add an apostrophe before the value (
).*‘450*

- Now, this will change the format of the number to text in your worksheet.

**Step 3:**

- Now, use the same procedure for the other numbers as well.

- Finally, you will see all the numbers in text format after converting.

**Read More:** **How to Convert Number to Text in Excel with Apostrophe**

### 4. Altering Cell Format to Convert Number to Text

In our last method, we will alter the format of the number cells to convert them into text. For that, do the followings.

**Step 1:**

- Firstly, select all the numbers in the data set.

**Step 2:**

- Then, from the
tab of the ribbon, go to the*Home*group.*Numbers*

- After that, from the
drop-down, choose*Number Format*as the format of the selected cells.*Text*

**Step 3:**

- Finally, you will find all the numbers in the cell will convert into text format as they will align from the left side.

**Read More:** **Excel VBA: Convert Number to Text with Format (A Total Guide)**

## Conclusion

That’s the end of this article. I hope you find this article helpful. After reading this article, you will be able to convert number to text in **Excel** by using any of these methods. Please share any further queries or recommendations with us in the comments section below.

**Related Articles**

**How to Convert Date to Text Month in Excel (8 Quick Ways)****Convert Date to Text YYYYMMDD (3 Quick Ways)****How to Convert Number to Text for VLOOKUP in Excel (2 Ways)****Convert Number to Text and Keep Trailing Zeros in Excel (4 Ways)****How to Convert Number to Text without Scientific Notation in Excel****How to Convert Number to Text with 2 Decimal Places in Excel (5 Ways)**