Checking for numeric values

[Tom21]

An easy one for you pro's out there.....

How do I go about checking for a 'numeric value only' in a cell, even if the cell is text based?

Cheers,

Tom.

 

[DarkSun]

Try this.

=ISNUMBER(A1*1)

the *1 is there to get round the text format problem.

 

[Tom21]

It's tellin' me that ISNUMBER isn't a function. I couldn't find the thing in the help file either.

I was looking at 'Cint' as a conversion function, but I don't know if I can put that in an if statement, becuase it'll probably throw up an error.....

In which case how would I deal with that?

I.E. If not error from function then
some code
end if

Nice one,

Tom.

 

[DarkSun]

Sorry, I thought you were in Excel not VBA!

use this.

Information.IsNumeric(MyVal)

Where MyVal is the value you are checking.

 

[Tom21]

That's done the trick. Thanks a lot mate.

Tom.