HOW TO CONVERT A FIGURE INTO TEXT IN EXCEL FILE. PLEASE LET US KN

Pl.let us know the equation for conversion of a figure into text
i.e. Rs.5000.00 (it is to be converted into FIVE THOUSAND ONLY) BY giving a
equation command in excel file.

There are a numbee of sites, but perhaps
http://support.microsoft.com/default...B;EN-US;213360
is the best place to start.

Originally Posted by ASHOKAN NAMBIAR

Pl.let us know the equation for conversion of a figure into text
i.e. Rs.5000.00 (it is to be converted into FIVE THOUSAND ONLY) BY giving a
equation command in excel file.

See:

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

and:

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

--
Gary's Student


"ASHOKAN NAMBIAR" wrote:

> Pl.let us know the equation for conversion of a figure into text
> i.e. Rs.5000.00 (it is to be converted into FIVE THOUSAND ONLY) BY giving a
> equation command in excel file.

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ASHOKAN NAMBIAR" <ASHOKAN [email protected]> wrote in
message news:[email protected]...
> Pl.let us know the equation for conversion of a figure into text
> i.e. Rs.5000.00 (it is to be converted into FIVE THOUSAND ONLY) BY giving
a
> equation command in excel file.