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
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