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

[Guest]

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.

 

[Guest]

See:

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

and:

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

 

[Bryan Hessey]

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)