How to convert amount in word format (Like 40.00 is Rs. Forty )
 

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

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

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