How can I convert numbers (ex. "4") to text (ex. "four")

[Help!]

I need to convert some numbers into text. For example, I have a cell with a
number "4", and I need to get a cell with a the text "four".

 

[Niek Otten]

Look here:

http://xldynamic.com/source/xld.xlFAQ0004.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need to convert some numbers into text. For example, I have a cell with a
| number "4", and I need to get a cell with a the text "four".

 

[Gary''s Student]

If A1 has a number like 1 or 2 or 3 or 4 then in another cell:

=CHOOSE(A1,"one","two","three","four")

 

[ato_zee]

I need to convert some numbers into text. For example, I have a cell with
a number "4", and I need to get a cell with a the text "four".

I believe Excel may have a lookup table capability, or you
could use an array. but if the range is large with values into
the hundreds this may not be an option.
I haven't seen a function that converts 1227 into
one thousand two hundred and twenty seven, but
Excel has a vast collection of obscure functions.
Problem with large numbers is that there is more
than one way to express them, 1227 to some is
twelve hundred and twenty seven.

 

[Ron Rosenfeld]

I need to convert some numbers into text. For example, I have a cell with a
number "4", and I need to get a cell with a the text "four".

Download and install Longre's free morefunc.xll add-in. Then use the NBTEXT
function.
--ron