IsNumeric Function |
Named Arguments
No
Syntax
IsNumeric(expression)
expression
Use: Required
Data Type: Any numeric or string expression
A numeric or string expression.
Return Value
Boolean (True or False).
Description
Determines whether expression can be evaluated as a number.
Rules at a Glance
If the expression passed to IsNumeric evaluates to a number, True is returned; otherwise, IsNumeric returns False.
Programming Tips and Gotchas
If expression is a date or time, IsNumeric evaluates to False.
If expression is a currency value, including a string that includes the currency symbol defined by the Control Panel's Regional Settings applet, IsNumeric evaluates to True.
Get VB & VBA in a Nutshell: The Language now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.