Is there a function to convert a number to word ?

[Guest]

I would like to know whether there is a ready-made function which converts
numerics into their corresponding words.

for eg. if the cell contains 1234, the function should return

one thousand two hundred thirty four

or atleast

one two three four

 

[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)