How can I make a number e.g. "14" appear as a word e.g. "fourteen.

G

Gil

I have searched help and web help all day, so I guess it is not a program
feature, but since Word's paragraph numbering is able to do it, I think the
next version of Excel should be able to. In any event, I am wondering if
anyone has made VBA script or anything to accomplish this. Converting
numbers to their English text equivalent, i.e. "14" to "fourteen" or "38.75"
to "thirty-eight point seventy-five". I know the decimal thing may be
over-complicated thing to write but at least just integers would be useful.
 
B

Bob Phillips

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


Gil said:
I have searched help and web help all day, so I guess it is not a program
feature, but since Word's paragraph numbering is able to do it, I think the
next version of Excel should be able to. In any event, I am wondering if
anyone has made VBA script or anything to accomplish this. Converting
numbers to their English text equivalent, i.e. "14" to "fourteen" or "38.75"
to "thirty-eight point seventy-five". I know the decimal thing may be
over-complicated thing to write but at least just integers would be
Click to expand...
useful.
 
R

Ron Rosenfeld

I have searched help and web help all day, so I guess it is not a program
feature, but since Word's paragraph numbering is able to do it, I think the
next version of Excel should be able to. In any event, I am wondering if
anyone has made VBA script or anything to accomplish this. Converting
numbers to their English text equivalent, i.e. "14" to "fourteen" or "38.75"
to "thirty-eight point seventy-five". I know the decimal thing may be
over-complicated thing to write but at least just integers would be useful.
Click to expand...

Download and install Laurent Longre's free morefunc.xll from
http://xcell05.free.fr/

Then:

=NBTEXT(38.75,,1,"point",,,,1)

will result in:

thirty-eight point seventy-five


Obviously, there are a number of arguments and the constants can be replaced by
cell references just like with other Excel functions; but it is a very flexible
function. And the add-in has many other functions, too.

--ron
 
G

Gil

Thank you Bob. Great info, very helpful, a few simple modifications and I
get exactly what I wanted "fourteen point seventy-five".
 
Top