Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forumla Needed: Text or Number Format
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forumla Needed: Text or Number Format
=IF(ISNUMBER(A1),"number","text")
-- Gary''s Student - gsnu201001 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forumla Needed: Text or Number Format
If I understood correctly - it might be:
=ISTEXT(A1) =ISNUMBER(A1) Micky "CM4@FL" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forumla Needed: Text or Number Format
OR, maybe: =CELL("type",A4)
*** browse the 'Help' to learn about that function *** Micky "CM4@FL" wrote: 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forumla Needed: Text or Number Format
Either that, or your previous suggestion of ISNUMBER or ISTEXT, will tell
you whether the cell CONTENT is number or text, but if the OP wants to know whether the cell FORMAT is number or text, perhaps =CELL("format",A4)? Remember that a cell may have text as a content, but be formatted as number, or vice versa. -- David Biddulph "????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message ... OR, maybe: =CELL("type",A4) *** browse the 'Help' to learn about that function *** Micky "CM4@FL" wrote: 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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forumla Needed: Text or Number Format
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 "David Biddulph" wrote: Either that, or your previous suggestion of ISNUMBER or ISTEXT, will tell you whether the cell CONTENT is number or text, but if the OP wants to know whether the cell FORMAT is number or text, perhaps =CELL("format",A4)? Remember that a cell may have text as a content, but be formatted as number, or vice versa. -- David Biddulph "????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message ... OR, maybe: =CELL("type",A4) *** browse the 'Help' to learn about that function *** Micky "CM4@FL" wrote: 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? . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forumla Needed: Text or Number Format
Formatting as number, =CELL("format",A1) doesn't return G, but, for example,
F2 if 2 decimal places (even if the content is text). -- David Biddulph "????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message ... 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 "David Biddulph" wrote: Either that, or your previous suggestion of ISNUMBER or ISTEXT, will tell you whether the cell CONTENT is number or text, but if the OP wants to know whether the cell FORMAT is number or text, perhaps =CELL("format",A4)? Remember that a cell may have text as a content, but be formatted as number, or vice versa. -- David Biddulph "????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message ... OR, maybe: =CELL("type",A4) *** browse the 'Help' to learn about that function *** Micky "CM4@FL" wrote: 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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incremental forumla needed | Excel Worksheet Functions | |||
Forumla help needed | Excel Discussion (Misc queries) | |||
converting a number to English text ( not to Baht) is needed | Excel Worksheet Functions | |||
help with forumla needed... getting a yes/no answer to ?? | Excel Worksheet Functions | |||
Help needed with cell category, ie Number/Text etc | Excel Discussion (Misc queries) |