See

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

--

HTH

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


"SVC" wrote in message
...
I want to convert the amount entered in excel sheet to their respective
text
value.
eg: 1,24,525
to be converted as
one lakh twenty four thousand five hundered and twenty five.