View Single Post
  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

Lous,

You are using Lotus 123's syntax, not Excel's.

Type in the formula
=SUM(f1:f24)

or use

Tools / Options... Transition tab, and check "Transition formula evaluation"

HTH,
Bernie
MS Excel MVP


"Louis1" wrote in message
...
When I type a formula like )" my cell is created with a
hyperlink to an email address, brings up Outlook, is really annoying.

I can remove the hyperlink of course, but it's a real pain.

I haven't been able to find a reference in the Help file. I did not
'turn' this feature on, so I assume it's a default.

Thanks for any help :)