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

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".

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

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Help!" wrote in message ...
|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".

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

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

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

--
Gary''s Student - gsnu200765


"Help!" wrote:

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".

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

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.

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

On Mon, 21 Jan 2008 12:13:01 -0800, Help!
wrote:

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