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

H

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

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")
 
A

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".
Click to expand...

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

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".
Click to expand...

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