Everybody knows that you can do amazing things with Excel, but who would imagine a function like BAHTTEXT? According to Microsoft, this function “Converts a number to Thai text and adds a suffix of Baht.” There are no functions that convert numbers to text in any other language, so why Microsoft chose to develop this function remains a mystery. I’m guessing that one of the developers did it to impress someone who speaks Thai…
Sadly, I don’t speak a word of Thai, so in order to determine whether or not the BAHTTEXT function is good enough to impress anyone, I checked the results in Google Translate. This is what I got:
This doesn’t make sense to me at all! I got the same result for 1 and 1000: “One thousand”. For 5 and 5000 I got almost the same result: “Five thousand only” and “Five thousand”. The results for 2 and 100 look correct, though.
So, who screwed up, Microsoft or Google? Please post a comment below if you can help me understand this!
More oddities in Excel:
Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.