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.
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
xcell05.free.fr/
when you have the add-in the formula for say dollars and cents would
be:
=NBTEXT(A2,2,1,quot;dollar!quot;,quot;dollarsquot;,quot;Centsquot;)
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=521505
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.
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
xcell05.free.fr/
when you have the add-in the formula for say dollars and cents would
be:
=NBTEXT(A2,2,1,quot;dollar!quot;,quot;dollarsquot;,quot;Centsquot;)
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=521505
文章標籤
全站熱搜
