Prev: Text data -- linking Excel sheets
Next: Can I title columns with out them having a row number?
From: Gord Dibben on 6 Feb 2010 11:05
OK.

A1 & A2 formatted as text or preceded by apostrophe.

In A3 =A1+A2 returns 3

=SUM(A1,A2) returns 0 which it should if A1 and A2 are text.

In both cases =ISNUMBER(A1) and A2 and A3 returns

FALSE, FALSE, TRUE

I give up<g>


Gord

On Fri, 05 Feb 2010 20:50:17 -0500, Ron Rosenfeld <ronrosenfeld(a)nospam.org>
wrote:

>On Fri, 05 Feb 2010 09:30:00 -0800, Gord Dibben <gorddibbATshawDOTca> wrote:
>
>>Ron
>>
>>Tested in my 2007 with new workbook.
>>
>>Format A1:A2 as Text
>>
>>A1 1
>>A2 2
>>
>>A3 =A1+A2 results in 0
>>
>>Same for '1 and '2
>>
>>
>>Gord
>
>Interesting.
>
>I just did it again, but this time on a different computer.
>
>Same results as I posted initially.
>
>Computer 1 is running W7x64; computer 2 is running XP SP3 (32 bit)
>
>XL version on computer 2 is Excel 2007 (12.0.6514.5000) SP2 MSO
>(12.0.6425.1000)
>
>I assume the version on my W7 machine is the same, but it's now a few hundred
>miles away, so I can't be sure.
>
>The other interesting phenomenon, that does occur on both machines, is that
>AFTER I enter =a1+a2 and see "3" as a result (without the quotes)
> the "3" is left justified
> the cell is formatted as TEXT
> =ISTEXT(B1) --> FALSE
> =ISNUMBER(B1) --> TRUE
> Selecting B1, then EDIT (F2) and <enter> displays just the formula, as
>one would expect in a text formatted cell.
>
>Very weird. But it's occurring on two different machines, two different OS's,
>same Excel 2007.
>
>--ron

From: Ron Rosenfeld on 6 Feb 2010 15:13
On Sat, 06 Feb 2010 08:05:47 -0800, Gord Dibben <gorddibbATshawDOTca> wrote:

>OK.
>
>A1 & A2 formatted as text or preceded by apostrophe.
>
>In A3 =A1+A2 returns 3
>
>=SUM(A1,A2) returns 0 which it should if A1 and A2 are text.
>
>In both cases =ISNUMBER(A1) and A2 and A3 returns
>
>FALSE, FALSE, TRUE
>
>I give up<g>
>
>
>Gord

So we do both have Excel's that work alike. (I agree that SUM(a1,a2)--> 0 and
the =a1+a2 --> 3)

And yet, the OP's does not, apparently. Unless there is something he has
omitted.
--ron
First  |  Prev  | 
Pages: 1 2 3
Prev: Text data -- linking Excel sheets
Next: Can I title columns with out them having a row number?