ISNUMBER function

There is currently no way no easy way to identify whether data is numeric or not. The workaround for X is to check the following set of conditions:

NOT (VALUE(X) <= 0 OR VALUE(X) >= 0)

Currently this is certainly not a consistent approach and there is always a risk that the comparison operators ("<=" and ">=") will start behaving differently which will lead to errors.

9
9 votes

New · Last Updated

Comments

  • Status changed to: New
  • I know this is old but just ran into this myself wanted to share in case anyone runs into this. I found that using Value (text)*0=0 works as anything that is not a number will return NaN and therefore fails the check.

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!