Excel 2007 : Convert number to text in Excel 2007

**kdill20** · 05-12-2010, 01:28 PM

I need help converting numbers to text in excel 2007. I have done it before in 2003, but can't seem to remember exactly what I used. I may have used some kind of conditional formating, but not sure.

Here is an example of what I need.

If I type "7203" in a cell I want "Home Repairs" to appear. I have a list of words associated with a list of numbers and want to be able to type the number in a cell and have the word appear.

An help would be greatly appreciated.

**JBeaucaire** · 05-12-2010, 01:32 PM

To change the actual number 7203 typed into a cell with text, that would require a macro.

To type 7203 into a cell and have text appear in the cell next to it related to that number, that can be done with formulas.

**royUK** · 05-12-2010, 01:34 PM

Use VLOOKUP

http://excel-it.com/excel_functions.htm

**kdill20** · 05-12-2010, 02:13 PM

Do you know of any way using conditional formating. I know i did not have to create a macro in 2003.

**JBeaucaire** · 05-12-2010, 04:47 PM

I'm using Excel 2003 and I can state to a certainty that there is no conditional fomatting that will convert the values in a cell from numbers to text. CF simply changes the font, font color, background and/or borders of cells.

To actually change one entered value for another will require:
1) VBA to do in same cell
2) Lookup formulas to do in another cell

**imneerajkumar** · 08-30-2010, 01:53 AM

Dear Friends,

Can i get any of example file where i can see the formula????

**royUK** · 08-30-2010, 02:12 AM

What formula? I've already suggested that VLOOKUP would be the way to go

**imabasit** · 10-04-2013, 07:36 AM

This is a bit late. But It's never too late.

I encounter the same problem today.

I added one more column and applied the formula Concatenate for the desired column of number.
After that I select this column, copy it and paste it special with text.

My issue is resolved. Check it ou

Originally Posted by kdill20

I need help converting numbers to text in excel 2007. I have done it before in 2003, but can't seem to remember exactly what I used. I may have used some kind of conditional formating, but not sure.

Here is an example of what I need.

If I type "7203" in a cell I want "Home Repairs" to appear. I have a list of words associated with a list of numbers and want to be able to type the number in a cell and have the word appear.

An help would be greatly appreciated.

**longfisher** · 05-26-2014, 11:26 AM

There's an incredibly simple way to convert a number to text. Use the trim function.

For example:

If cell A1 contained the value 23 then if cell A2 contained the formula =type(A1) would return the value 1, indicating that the cell A1 contained a number.

But if the formula =type(trim(A1)) would return the value 2, indicating that cell A1 contained text.

Longfisher