convert number into corrseponding text

[Guest]

Hi,

I would like to know if there is a way to display text on the corresponding
number.

eg.
I type 530,000
and it would show me Five hundred and thirty thousand

 

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

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