IsNumeric in Open Office Basic or VBA

Question

Is there a function that tests for a string (non numeric) values and returns a boolean value in Open Office Basic?

I tried IsNumeric on a string and it returns a boolean False. But when I negate it with Not(IsNumeric(value)), it converts the return value to a long or an int.

Answer 1

For Open Office Basic, you can use ISNUMBER()

ISNUMBER(123)

returns TRUE.