A to Z of Excel Functions: The ISTHAIDIGIT Function

Welcome back to our regular A to Z of Excel Functions blog.  Today, we look at the ISTHAIDIGIT function.

The ISTHAIDIGIT function

The ISTHAIDIGIT function in Excel is a one of several functions that is support the Thai language in Microsoft Excel.  We are not quite sure why there is such favouritism, but it exists nonetheless.

This function is designed to determine whether a given character or string of characters consists entirely of Thai digits.  It is thought the syntax of the function is of the form

where:

• text is a required argument and represents the text or cell reference that you want to check for Thai digits. This text may be a single character or a string of characters.

It appears to be no longer operational but is still recognised in Excel, viz. 

This function is presented for completeness only and is denoted as “internally reserved”.  It does not appear to work in any generally available current versions of Excel.

Theoretically, the ISTHAIDIGIT function should work as follows:

This should return TRUE because the string "๕๖๗" consists entirely of Thai digits.

This should return FALSE because the string "๕6๗" contains a non-Thai digit (6).

Assuming cell A1 contains the text "๓๔๕", this should return TRUE.

Presently, this function tends to return #VALUE! but it may return to Excel in a functioning capacity in the future (we have no idea!).

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every business day.