checking the presence of any of the character from a certain set of characters in an Excel cell, and returning values accordingly
I have a data set in which there are several cells that should contain numbers but are formatted as text.
What I am trying to do is enter a formula that checks for the presence of any of the following charcters (0, 1, 2,3, 4, 5, 6, 7, 8, 9), and if found returns the value in the cell as a NUMBERVALUE, otherwise returns the value of the cell as it is.