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

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"

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

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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