Thread: How to convert amount in word format (Like 40.00 is Rs. Forty )
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How to convert amount in word format (Like 40.00 is Rs. Forty )

Yes, see:

How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...EN-US;Q213360&

--
Gary's Student


"Dinesh" wrote:

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