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