You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
it looks like the ISNUMBER(value) function returns true only when the text is a number with a decimal separator.
The regex used to check the value is /^-?\d*(\.\d+)+$/ with the (\.\d+)+ bit meaning one or more group of characters consisting of a point and one or more digit.
I think something like this could work better: /^-?\d*\.?\d+$/
Or, if you want to accept numbers with a trailing dot like "123.", you can change the last \d+ to \d*: /^-?\d*\.?\d*$/