Take a look at

http://www.xldynamic.com/source/xld.xlFAQ0004.html
Excel FAQs - Convert Numbers To Text

--

HTH

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


"CHA Salam" <CHA wrote in message
...
Dears, Is there a function or a way to change automatically a number
typed
in a cell (eg: 100) as in tex format? (i.e Hundred)?

Kind regards,
Abdulssalam CH