"1" + "2" = 0 (?)not what Help says

[heknip]

On one worksheet in a workbook

"1" + "2" = 0

However, for all other worksheets in this workbook (and my other
worksheets)

"1" + "2" = 3

Excel Help says"
"When you use a plus sign (+), Microsoft Excel expects numbers i
the formula. Even though the quotation marks mean that "1" and "2" ar
text values, Microsoft Excel automatically converts the text values t
numbers."


Any suggestions or explanation?
Thanks
Hug

 

[heknip]

Also for the worksheet where "1" + "2" = 0
"dog" + 1 = 1
while for all other worksheets
"dog" + 1 = #VALUE!

I am using Excel 2000

Hug

 

[J.E. McGimpsey]

Go to Tools/Options/Transition and uncheck the Transition Formula
Evaluation checkbox.

 

[heknip]

Got it.
Many thanks
Hug