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

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dinesh" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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
>
>