Home |
Search |
Today's Posts |
#1
|
|||
|
|||
About =bahttext()
Any one dear can solve my problem?
I just want to use this function or any other substitute to conver numeric vlaue in text value in english. Because we know that this function converts numeric value in thai language. But how can it converts in english? For example 125 after apply this function ther anwer should be- One Hundred Twenty Five |
#2
|
|||
|
|||
I know that of something similar that works with Word
"Rao Ratan Singh" wrote in message ... Any one dear can solve my problem? I just want to use this function or any other substitute to conver numeric vlaue in text value in english. Because we know that this function converts numeric value in thai language. But how can it converts in english? For example 125 after apply this function ther anwer should be- One Hundred Twenty Five |
#3
|
|||
|
|||
Quite ugly solution, but you can just convert the numeric value to a string
then just start to parse out one at a time. You will need to have many case statements. For example : If the 3rd value of the string is "1", add "one hundred" to the output text. There must be someone out there that has already done this. Kenjiro Yagi On 12/3/04 12:43 AM, in article , "D@annyBoy" wrote: I know that of something similar that works with Word "Rao Ratan Singh" wrote in message ... Any one dear can solve my problem? I just want to use this function or any other substitute to conver numeric vlaue in text value in english. Because we know that this function converts numeric value in thai language. But how can it converts in english? For example 125 after apply this function ther anwer should be- One Hundred Twenty Five |
#4
|
|||
|
|||
which version of Excel?
try =dollar() "Rao Ratan Singh" wrote in message ... Any one dear can solve my problem? I just want to use this function or any other substitute to conver numeric vlaue in text value in english. Because we know that this function converts numeric value in thai language. But how can it converts in english? For example 125 after apply this function ther anwer should be- One Hundred Twenty Five |
#5
|
|||
|
|||
me bad, it not the one that you want
sorry "D@annyBoy" wrote in message ... which version of Excel? try =dollar() "Rao Ratan Singh" wrote in message ... Any one dear can solve my problem? I just want to use this function or any other substitute to conver numeric vlaue in text value in english. Because we know that this function converts numeric value in thai language. But how can it converts in english? For example 125 after apply this function ther anwer should be- One Hundred Twenty Five |
#6
|
|||
|
|||
you want to try this
http://www.barasch.com/excel/numb2words.htm "Rao Ratan Singh" wrote in message ... Any one dear can solve my problem? I just want to use this function or any other substitute to conver numeric vlaue in text value in english. Because we know that this function converts numeric value in thai language. But how can it converts in english? For example 125 after apply this function ther anwer should be- One Hundred Twenty Five |
#7
|
|||
|
|||
You've been told many times now, by many different knowledgeable people,
that there's no XL function that returns English words in the way BAHTTEXT() does. Asking again and again won't change that. Try using the workarounds that have been provided. In article , Rao Ratan Singh wrote: Any one dear can solve my problem? I just want to use this function or any other substitute to conver numeric vlaue in text value in english. Because we know that this function converts numeric value in thai language. But how can it converts in english? For example 125 after apply this function ther anwer should be- One Hundred Twenty Five |
#8
|
|||
|
|||
You beat me to it J.E.
many times now......probably near to a dozen Gord On Fri, 03 Dec 2004 07:28:48 -0700, JE McGimpsey wrote: You've been told many times now, by many different knowledgeable people, that there's no XL function that returns English words in the way BAHTTEXT() does. Asking again and again won't change that. Try using the workarounds that have been provided. In article , Rao Ratan Singh wrote: Any one dear can solve my problem? I just want to use this function or any other substitute to conver numeric vlaue in text value in english. Because we know that this function converts numeric value in thai language. But how can it converts in english? For example 125 after apply this function ther anwer should be- One Hundred Twenty Five |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
about =bahttext() | Excel Worksheet Functions | |||
About =bahttext() | Excel Worksheet Functions | |||
About =bahttext() | Excel Worksheet Functions | |||
about worksheet function =bahttext | Excel Worksheet Functions |