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.