Hello,
How to check if values in a cell are numeric or contains only numbers using formula tool?
@Vaib
Ah, if they're coming in as text fields you could try the 'IsInteger' function. That would check if it would be able to be converted to a number. See attached example.
There is a 'isnumber' function you could use:
Hi @Luke_C,
I wasn't aware that there is a formula like this.
Thank you for sharing.
The isnumber function doesnot seem to be working for me. I have date in the cell that I am looking at in the following format 20200331 (yyyymmdd). I just need to check if the value 20200331 is numeric or not.
Thanks for the solution
