# Three Ways to Convert Number to Text in Excel

Before we have wrote a post to describe that how to convert number to Text string with Text Function in excel. This post will guide you how to convert number to Text using The Format Cells Command and Text to Columns wizard in excel.

## Convert Number to Text Using Format Cells Option

You also can be used the Format Cells option to change the number to Text string in excel.  It may be another quick way to change the numeric value to text string in excel.

1# select the range with the numbers that you want to convert to text. 2#Right-click the selected range in the step1, and then click “Format Cells...” item from the pop-up menu list. 3# Format Cells” window will appear. 4# Select “Text” under the Number tab and then click OK button. ## Convert Number to Text Using Text to Columns wizard

1# Select the column that you want to convert numbers to text string 2# click on the “Text to Columns” button under DATA tab on excel ribbon. 3#Convert Text to Columns Wizard” window will appear. 4# click “next” button through step 1 and step 2. Select “Text” radio button under step 3. Then click on “Finish” button. You will see that the numbers is converted to text now.

## Convert Number to Text Using Concatenate Operator

We can also use another way to change the numeric value to string using Excel Concatenate operator.

The concatenation operator (&) can join together text and numbers into a single text string in excel. So if you just concatenate an empty text string (such as: “”) and a numeric value together, the returned value will be a text string. Let’s see the below example:

`=""&A1` You need to enter the above excel formula in the B1 cell, then click “enter”. You will see that the numeric value in Cell A1 be changed as text string in B1.

Also read: Excel Convert numbers to Text

Related Posts

Excel Formulas To Calculate The Bond Valuation

Assume that you've been assigned a task of calculating bond valuation; so if you are new to Ms Excel or do not have much experience with it, then I am pretty sure about it that doing this task manually might ...

Calculate Cumulative Totals with Excel SUM Function

Today, through a simple example, we will show you how to use one of the most common-used Mathematical functions in excel, the SUM function, to add up the sum. In our daily life, we keep an account of what we ...

BMI Calculation Formula In Ms Excel

You might have come across a task in which you were assigned to make BMI calculations of the supplied numbers, and you may be looking for an efficient approach to accomplish this process rather than doing BMI calculations manually, by ...

Calculate The Period of Loan or Investment in Excel

In our daily life, most of us will invest or take a loan, so we need to master some simple financial functions to calculate the period needed for loans or investments. If you work as an accountant, you need to ...

Working Time Calculation Based on Timesheets

In the office, a special machine record the time when you start working (clock in office) and when you finish working (clock out of office). We can calculate the total working time by subtracting the end working time from the ...

How to apply a formula in entire column or row without/with dragging

This post explains that how to apply an excel formula in entire column or row through dragging fill handler in excel. How do I apply formula in entire column or row without dragging fill handler by shortcut or Fill command. ...

Get the Current Workbook Name

This post explains how to get the current workbook name in excel. Get the Current Workbook Name In excel, the CELL function can get the information of the current worksheet, it will return the full file name and its path. ...

Split Text and Numbers in Excel

This post explains how to split text and numbers in excel, or how to extract the text characters from another strings with text and numbers combined. Split Text and Numbers If you want to split text and numbers, you can ...

Split Text String by Specified Character in Excel

This post explains how to split text string by a specified character (such as: comma, space, dash, slash, etc.) using FIND function within other functions in excel. And you will learn that how to extract part of characters to the ...

Excel Replace Function Remove Text String

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you ...

Sidebar