| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
About function BAHTTEX
Hi,
this is regarding the function BATHTTEX.. I know that this fuction converts the number into word. ie 5000 = Five Thousand but when ever i use this i get the out as ห้าหมื่นบาทถ้วน I dont know what to do. Pkls help. Akash |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About function BAHTTEX
Akash,
That's why it's called BAHTTTEXT, it outputs the amount in Thai, ie. in the Thai currency of Baht. Now why MS decided to provide such a function in Thai it anyone's guess, although I did read that it was related to paying the bill at the programmers' favourite Thai restaurant... NickHK "Akash" wrote in message s.com... Hi, this is regarding the function BATHTTEX.. I know that this fuction converts the number into word. ie 5000 = Five Thousand but when ever i use this i get the out as ??????????????? I dont know what to do. Pkls help. Akash |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About function BAHTTEX
Dear Nick
Pls do help me by giving the proper resolution to this.... Regards Akash On Dec 18, 12:01 pm, "NickHK" wrote: Akash, That's why it's called BAHTTTEXT, it outputs the amount in Thai, ie. in the Thai currency of Baht. Now why MS decided to provide such a function in Thai it anyone's guess, although I did read that it was related to paying the bill at the programmers' favourite Thai restaurant... NickHK "Akash" wrote in legroups.com... Hi, this is regarding the function BATHTTEX.. I know that this fuction converts the number into word. ie 5000 = Five Thousand but when ever i use this i get the out as ??????????????? I dont know what to do. Pkls help. Akash |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About function BAHTTEX
That is the resolution - it outputs a number in Thai. Read the help.
NickHK "Akash" wrote in message oups.com... Dear Nick Pls do help me by giving the proper resolution to this.... Regards Akash On Dec 18, 12:01 pm, "NickHK" wrote: Akash, That's why it's called BAHTTTEXT, it outputs the amount in Thai, ie. in the Thai currency of Baht. Now why MS decided to provide such a function in Thai it anyone's guess, although I did read that it was related to paying the bill at the programmers' favourite Thai restaurant... NickHK "Akash" wrote in legroups.com... Hi, this is regarding the function BATHTTEX.. I know that this fuction converts the number into word. ie 5000 = Five Thousand but when ever i use this i get the out as ??????????????? I dont know what to do. Pkls help. Akash |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
About function BAHTTEX
If you mean you want to spell out numbers as words, then take your pick from
: http://www.google.co.uk/search?hl=en...S earch&meta= or limit the search to the language of your choice. NickHK "Akash" wrote in message oups.com... Dear Nick Pls do help me by giving the proper resolution to this.... Regards Akash On Dec 18, 12:01 pm, "NickHK" wrote: Akash, That's why it's called BAHTTTEXT, it outputs the amount in Thai, ie. in the Thai currency of Baht. Now why MS decided to provide such a function in Thai it anyone's guess, although I did read that it was related to paying the bill at the programmers' favourite Thai restaurant... NickHK "Akash" wrote in legroups.com... Hi, this is regarding the function BATHTTEX.. I know that this fuction converts the number into word. ie 5000 = Five Thousand but when ever i use this i get the out as ??????????????? I dont know what to do. Pkls help. Akash |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
