Make decisions

Check if a cell holds a number

How it works in Excel

• ISNUMBER is true only for real numbers.
• Numbers stored as text fail this test, so it is a good way to find them.
• ISTEXT checks for text.

The idea in general

It looks past how a cell appears, to what it really holds.

What I assumed

• The cell to check is A2.

Check the result on your own data before relying on it.