Microsoft Office Development and Consultancy
 Home|Excel|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 VBA > Syntax > Other > ISNUMERIC
 ISNUMERIC(expression)
 Returns the value indicating if an expression contains a number (Boolean).

 expressionThe expression to test.

 REMARKS
 
  		• The "expression" can be any numeric or string expression.
     
  		• If "expression" contains a date expression, then it returns False.
     
  		• This function is used a lot to test if a text string can be converted to a number.

     EXAMPLES
     
    IsNumeric(123) = True
    IsNumeric(10.23) = True
    IsNumeric("123") = False
    IsNumeric("01/12/2012") = False
    IsNumeric("20/12/2012") = False
    IsNumeric("12/20/2012") = False
    IsNumeric("12/01/2012") = False
    IsNumeric(#1/12/2012#) = False
    IsNumeric("abc") = True
    		 
     Syntax - I | Index - I 

     © 2013 Better Solutions Limited. All Rights Reserved.Top | 02-Jan-2013