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

Dinesh · Dec 29, 2005

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

Bob Phillips · Dec 29, 2005

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

Gary''s Student · Dec 29, 2005

Yes, see:

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

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

Dinesh

Bob Phillips

Gary''s Student