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" <Dinesh@discussions.microsoft.com> wrote in message
news:EA0668EA-7A00-4036-A787-A16939314899@microsoft.com...
> 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
>
>