Why does using @SUM in EXL 2002 trigger an O/L "new" email ?

[Guest]

When I use @SUM in Excel 2002, the result is a "hot button" that generates a
new Oulook email with the "address" showing the formula.

How can i get rid of the "hot button" result?

PS: Using @COUNTA and other functions does not yield the same result.

 

[Bernie Deitrick]

Retireee,

Don't use @ when entering functions - use the = sign instead, which is Excel's style.

=SUM(A1:A10)

HTH,
Bernie
MS Excel MVP

 

[Guest]

I have this same problem, it's driving me nuts. I have Excel 2003. Does
anyone else run into this problem. Any solutions?

 

[Dave Peterson]

@ was used by Lotus 123 as the function indicator.

@ is also the character used in an email address.

If you're using Excel, stop using @sum().

If your formula starts with that function, then use an equal sign:
=sum(a1:a10)

If your formula contains that function, you don't need it:

=if(a1>7,sum(b1:b12),average(c1:c9))

========
If you really must continue the use of @ (fingers won't stop typing it????), you
can turn off the feature that turns those strings into hyperlinks:

Tools|Autocorrect options|Autoformat as you type tab
Uncheck that "replace as you type" option (Internet and network paths with
hyperlinks)