Prev: How to clear clipboard memory?
Next: Calculating Age NOT as of today but as of a date in the future
From: CM4 on 6 Apr 2010 13:20
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?
From: Gary''s Student on 6 Apr 2010 13:29
=IF(ISNUMBER(A1),"number","text")

--
Gary''s Student - gsnu201001
From: מיכאל (מיקי) אבידן on 6 Apr 2010 13:31
If I understood correctly - it might be:
=ISTEXT(A1)
=ISNUMBER(A1)
Micky


"CM4(a)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?
From: מיכאל (מיקי) אבידן on 6 Apr 2010 13:35
OR, maybe: =CELL("type",A4)
*** browse the 'Help' to learn about that function ***
Micky


>
>
> "CM4(a)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?
From: "David Biddulph" groups [at] on 6 Apr 2010 14:54
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
news:2BF58AB3-C337-4AB2-84BD-E0F42AD8ECE3(a)microsoft.com...
> OR, maybe: =CELL("type",A4)
> *** browse the 'Help' to learn about that function ***
> Micky
>
>
>>
>>
>> "CM4(a)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?


 |  Next  |  Last
Pages: 1 2
Prev: How to clear clipboard memory?
Next: Calculating Age NOT as of today but as of a date in the future