ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW TO CONVERT A FIGURE INTO TEXT IN EXCEL FILE. PLEASE LET US KN (https://www.excelbanter.com/excel-discussion-misc-queries/50648-how-convert-figure-into-text-excel-file-please-let-us-kn.html)

ASHOKAN NAMBIAR

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.

Gary''s Student

HOW TO CONVERT A FIGURE INTO TEXT IN EXCEL FILE. PLEASE LET US KN
 
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.


Bryan Hessey

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

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


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.



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=476577


Bob Phillips

HOW TO CONVERT A FIGURE INTO TEXT IN EXCEL FILE. PLEASE LET US KN
 
See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ASHOKAN NAMBIAR" <ASHOKAN wrote in
message ...
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.





All times are GMT +1. The time now is 11:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com