Forumla Needed: Text or Number Format

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coping forumalted answers 1
Digits to the right of decimal point 3
Excel Formula Missing Cells Due To Hardware 2
Vlookup 1
Forumla rows and columns 3
Formula to identify decimal versus whole numbers 12
=ISFUNCTION 5
Can I protect data in a cell, but allow comments to be entered. 6

Top