Is there a function to convert a number to word ?
 

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

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

--

HTH

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


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