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.

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

--

HTH

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


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

On Wed, 25 May 2005 12:39:08 -0700, Gil wrote:

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.

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

Thank you very much Ron, great info, very helpful.

"Ron Rosenfeld" wrote:

On Wed, 25 May 2005 12:39:08 -0700, Gil wrote:

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.

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

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

"Bob Phillips" wrote:

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

--

HTH

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


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