HOW DO WE CHANGE THE FORMAT OF FUNCTION =BAHTTEXT( ) TO ENGLISH?
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. |
HOW DO WE CHANGE THE FORMAT OF FUNCTION =BAHTTEXT( ) TO 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 |
All times are GMT +1. The time now is 03:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com