Excel Tip: Convert Number to Text

Here are four basic ways to convert a number in a cell to text.

Method (1) Format Cells

1) Right click cell(s) of interest and click on “Format Cells…”

2) Under the Number tab Choose Text as your Category

Method (2) Text function

1) use the TEXT function.  It has the formatting of =TEXT(Value,Format)

For example, =TEXT(42.6,”0.00″) returns 42.60 as a text value.  The formatting is the same as that used in the Format Cells dialogue box.

Method (3) Concatenation with &

Using the ampersand (&), you can concatenate text.  For example, the formula =”a”&”b” returns ab.  If you concatenate any text to a number (including a null text such as “”) it will return a text value.  So, typing the formula =””&70.0 returns 70 as a text.  Note the formatting isn’t as convenient as using the TEXT function.

Method (4) Text to Columns

Choosing Data -> Text To Columns from the menu will let you convert your numbers to text.  When the dialogue opens up just follow the steps in the Wizard:

Step 1) Choose Delimited and click Next.

Step 2) Tab delimited and click Next.

Step 3) Choose Text as your Coumn Data Format and click Finish.

This entry was posted in Excel, software and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *