Forumla Needed: Text or Number Format

  • Thread starter Thread starter CM4@FL
  • Start date Start date
C

CM4@FL

What is the forumla that allows tells you if data is in text or number
format. I remember using it before but can't seem to remember it?
 
If I understood correctly - it might be:
=ISTEXT(A1)
=ISNUMBER(A1)
Micky
 
OR, maybe: =CELL("type",A4)
*** browse the 'Help' to learn about that function ***
Micky
 
Well..., I formatted cell A1 as TEXT and typed: Bla bla.
The formula: =CELL("format",A1) - returns: G
I don't remember that there is an 'Info_type' checking for Text Format.
I might be mistaken...
Micky
 
Back
Top