Prev: How to clear clipboard memory?
Next: Calculating Age NOT as of today but as of a date in the future
From: מיכאל (מיקי) אבידן on 6 Apr 2010 16:09
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
> 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?
>
>
> .
>
From: "David Biddulph" groups [at] on 6 Apr 2010 17:17
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
news:1B13C5AE-6224-4174-A992-7F1C9CB8F61A(a)microsoft.com...
> 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
>> 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?
>>
>>
>> .
>>

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