http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Narendra" wrote in message
...
I have reports to be generated where the Numbers or Numerical value is to
mentioned in Words Like 1,100-00 as One thousand one hundred only.