ello,

Is it possible to see how a particular is formatted for ?

I did a little experimenting, and it seems that if I put in text, or
numbers, and go to Format Cell, it "seems" to indicate the Format is
General, for both.

Is there some command that would return an inquiry to a text cell as it
truly being "Text" ?

And, I understand that text when entered shows up to the left of the
cell, numbers to the right. If I change the left-right position with
the Alignment buttons, does this change the actual Format of the cell ?

Thanks,
Bob

See help on Information Functions, specifically the CELL function which returns
type of format.

Changing alignment does not change format.

Note that a valid Date is a number so ISNUMBER will return TRUE


Gord Dibben MS Excel MVP

On Thu, 02 Dec 2010 12:41:44 -0500, Bob <(E-Mail Removed)> wrote:

>ello,
>
>Is it possible to see how a particular is formatted for ?
>
>I did a little experimenting, and it seems that if I put in text, or
>numbers, and go to Format Cell, it "seems" to indicate the Format is
>General, for both.
>
>Is there some command that would return an inquiry to a text cell as it
>truly being "Text" ?
>
>And, I understand that text when entered shows up to the left of the
>cell, numbers to the right. If I change the left-right position with
>the Alignment buttons, does this change the actual Format of the cell ?
>
>Thanks,
>Bob

Hi,

Thanks for help.

I guess I should have mentioned that I'm reall dumb with this;
new user, truly.

I looked at where you suggested, and found:

info_type Required.

A text value that specifies what type of cell information you want to
return. The following list shows the possible values of the info_type
argument and the corresponding results.
info_type Returns "address" Reference of the first cell in reference,as
text.

O.K. I click in the cell that I'm interested in know if it is formatted
as Text or as a Number.

Now, specifically what do I do next, please ?
What do I type for info_type ?
Where do I type it ?
etc.

Thanks again,
Bob
-------------



On 12/2/2010 2:46 PM, Gord Dibben wrote:
> See help on Information Functions, specifically the CELL function which returns
> type of format.
>
> Changing alignment does not change format.
>
> Note that a valid Date is a number so ISNUMBER will return TRUE
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 02 Dec 2010 12:41:44 -0500, Bob<(E-Mail Removed)> wrote:
>
>> ello,
>>
>> Is it possible to see how a particular is formatted for ?
>>
>> I did a little experimenting, and it seems that if I put in text, or
>> numbers, and go to Format Cell, it "seems" to indicate the Format is
>> General, for both.
>>
>> Is there some command that would return an inquiry to a text cell as it
>> truly being "Text" ?
>>
>> And, I understand that text when entered shows up to the left of the
>> cell, numbers to the right. If I change the left-right position with
>> the Alignment buttons, does this change the actual Format of the cell ?
>>
>> Thanks,
>> Bob

To find things out about a cell you do not click in that cell.

You select another cell and write a formula referring to the cell in question.

Type your name into A1

In B1 enter =ISTEXT(A1)

Should return TRUE

In C1 enter =ISNUMBER(A1)

Should return FALSE

For info-type you would enter in D1 =CELL("type",A1)

Will return l indicating text as in "label"


Gord


On Fri, 03 Dec 2010 10:06:22 -0500, Bob <(E-Mail Removed)> wrote:

>Hi,
>
>Thanks for help.
>
>I guess I should have mentioned that I'm reall dumb with this;
>new user, truly.
>
>I looked at where you suggested, and found:
>
>info_type Required.
>
>A text value that specifies what type of cell information you want to
>return. The following list shows the possible values of the info_type
>argument and the corresponding results.
>info_type Returns "address" Reference of the first cell in reference,as
>text.
>
>O.K. I click in the cell that I'm interested in know if it is formatted
>as Text or as a Number.
>
>Now, specifically what do I do next, please ?
>What do I type for info_type ?
>Where do I type it ?
>etc.
>
>Thanks again,
>Bob
>-------------
>
>
>
>On 12/2/2010 2:46 PM, Gord Dibben wrote:
>> See help on Information Functions, specifically the CELL function which returns
>> type of format.
>>
>> Changing alignment does not change format.
>>
>> Note that a valid Date is a number so ISNUMBER will return TRUE
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Thu, 02 Dec 2010 12:41:44 -0500, Bob<(E-Mail Removed)> wrote:
>>
>>> ello,
>>>
>>> Is it possible to see how a particular is formatted for ?
>>>
>>> I did a little experimenting, and it seems that if I put in text, or
>>> numbers, and go to Format Cell, it "seems" to indicate the Format is
>>> General, for both.
>>>
>>> Is there some command that would return an inquiry to a text cell as it
>>> truly being "Text" ?
>>>
>>> And, I understand that text when entered shows up to the left of the
>>> cell, numbers to the right. If I change the left-right position with
>>> the Alignment buttons, does this change the actual Format of the cell ?
>>>
>>> Thanks,
>>> Bob

You are correect Ron

Excel does not distinguish between Text or General using any of the CELL
arguments

=CELL("format",A1) will return G if A1 contains text

ISTEXT would have to employed.

I posted that alternative.


Gord

On Fri, 03 Dec 2010 15:49:54 -0500, Ron Rosenfeld <(E-Mail Removed)> wrote:

>On Fri, 03 Dec 2010 08:51:36 -0800, Gord Dibben <(E-Mail Removed)>
>wrote:
>
>>For info-type you would enter in D1 =CELL("type",A1)
>>
>>Will return l indicating text as in "label"
>>
>>
>>Gord
>
>If I understand the OP correctly, I think he wants to know whether the
>cell is formatted as General or Text.
>
>I believe the "type" parameter will return l regardless of the
>formatting of the cell, if it contains "label"