isnum

Syntax:

Value Boolean  isnum(Range source)

Description:

Return true if all cells in source are numeric, false otherwise.

Examples:

($d1:$d5) = isnum($a:$c)
Before:
AB CD
114-
2apple1.234
3five%13
41211-13
5six52
6
After:
AB CD
114-false
2apple1.234false
3five%13false
41211-13true
5six52false
6
($a1) = isnum($b1:$d20)