🔍 The Data Type Scanner

Goal: Check the data type of a cell.
ISNUMBER: Returns TRUE for real numbers.
ISTEXT: Returns TRUE for any text string.

ISNUMBER()
-
ISTEXT()
-
?
Ready...

💻 Formula Structure

=ISNUMBER(value)
  • Check: Is it a valid numeric value? (Includes Dates & Percentages).
  • Result: TRUE or FALSE.
=ISTEXT(value)
  • Check: Is it a text string?
  • Includes: "Text Numbers", Spaces, Symbols.
-- Check Cell A1
=ISNUMBER( A1 )
Logic Result:
-

⚠️ Common Pitfalls

🚫 Numbers as Text
A cell containing "123" (note the quotes or green triangle) is Text. ISNUMBER will return FALSE. This breaks math formulas like SUM.
✅ Fixing It
Use the VALUE function or multiply by 1 (A1*1) to force text-numbers back into real numbers.