how i convert "100" to "hundred"( number to text) in excel-2007

[mohanraj]

i don't know vb.is there any formula or function in excel 2007 to do the
following convertion.
number "100" convert in to text"hundred"

 

[Niek Otten]

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|i don't know vb.is there any formula or function in excel 2007 to do the
| following convertion.
| number "100" convert in to text"hundred"
|