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

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.

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

Retireee,

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

=SUM(A1:A10)

HTH,
Bernie
MS Excel MVP


"Retiree" wrote in message
...
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.

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

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


"Retiree" wrote:

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.

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

@ 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(a17,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)

f. eugene wrote:

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

"Retiree" wrote:

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.

--

Dave Peterson