Skip to main content


Returns whether a value is numeric.




string An expression that resolves to a string or numeric.


The NUM function determines whether a value is numeric or non-numeric. If string is a non-numeric value, NUM returns 0. If string is a numeric value, NUM returns 1. A numeric value can contain the numerals 0 through 9, plus and minus signs, and the decimal point. NUM also returns 1 for the null string.

You can use the NUMS function to make the same determination of each element of a dynamic array.

See Also

FeedbackOpens in a new tab