FInd whether a cell in a row is a number or not


#1

I would like to find whether any cell is a number or not in an excel.


#2

Hey @renjith_krishnan

You can try with this:

double myNum = 0;
String testVar = “Not A Number”;

if (Double.TryParse(testVar, out myNum)) {
// it is a number
} else {
// it is not a number
}

Regards…!!
Aksh


#3

thanks @aksh1yadav, i already got it though
there is a function called IsNumeric.