Name

IsNumeric Function

Syntax

IsNumeric(expression)
expression

Use: Required

Data Subtype: 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 & 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 VBScript in a Nutshell 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.