About =bahttext()

[Rao Ratan Singh]

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

 

[D@annyBoy]

I know that of something similar that works with Word

 

[Kenjiro Yagi]

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

 

[D@annyBoy]

which version of Excel?

try =dollar()

 

[D@annyBoy]

me bad, it not the one that you want

sorry

which version of Excel?

try =dollar()

 

[D@annyBoy]

you want to try this
http://www.barasch.com/excel/numb2words.htm

 

[JE McGimpsey]

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.

 

[Gord Dibben]

You beat me to it J.E.

many times now......probably near to a dozen

Gord