Thread: How to convert amount in word format (Like 40.00 is Rs. Forty )
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default How to convert amount in word format (Like 40.00 is Rs. Forty )
See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dinesh" wrote in message
...
I want to convert a value of cell in word format,

Like i have a value in cell is 40000.00

(i want to convert it into Rs. Forty Thousand Only)

is there any formula in excel for this function




Reply With QuoteReply With Quote