Functions
ISNUMBER
True if value is a number
Try it
When to use it
When should I use ISNUMBER?
Use ISNUMBER to test whether a cell holds a real number before doing math on it, often inside an IF to guard against text values.
Does ISNUMBER treat a number stored as text as a number?
No — a numeric string like the text 100 is not a number, so ISNUMBER returns FALSE until you convert it with VALUE.
Use cases
Confirm text is not mistaken for a number
Verify a converted string is now numeric
Used in
Syntax
ISNUMBER(value)