THE BAHTTEXT FUNCTION RETURNS THE VALUE OF A NO. IN BAHT TEXT. IN THE HELP OF
THAT PARTICULAR FUNCTION, IT SAYS THAT THIS FOIRMAT CAN BE CHANGED TO OTHER
FORMATS BY MAKING CHANGES IN THE REGIONAL SETTINGS OF THE CONTROL PANEL. I
TRIED, BUT COULD NOT DO SO. CAN ANY BODY PASS ME DETAILES STEPS ON HOW IT CAN
BE DONE. i WANT IT IN ENGLISH.

http://support.microsoft.com/default...b;en-us;213360

this ms link shows you how to convert numbers to text

or you can download an add-in called more functions, you can get it
here

http://xcell05.free.fr/

when you have the add-in the formula for say dollars and cents would
be:

=NBTEXT(A2,2,1,"dollar!","dollars","Cents")
;)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521505