Thread: Excel 2003 - don't want hyperlink with @sum()

When I type a formula like "@sum(f1..f24)" 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

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" <louis@_n0sp3m_HoustonBookClub.com> wrote in message
news:t99uj1lsf70dt3u8334emgh5j7puc7uuo4@4ax.com...
> When I type a formula like "@sum(f1..f24)" 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

Jeepers! I'm so embarrassed. I've just been doing that "@sum" stuff
for years, and it never dawned on me it would cause me trouble down
the road

Thanks very much ! Helps tremendously.

Louis

On Mon, 3 Oct 2005 10:24:33 -0400, "Bernie Deitrick" <deitbe @
consumer dot org> wrote:

>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" <louis@_n0sp3m_HoustonBookClub.com> wrote in message
>news:t99uj1lsf70dt3u8334emgh5j7puc7uuo4@4ax.com...
>> When I type a formula like "@sum(f1..f24)" 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
>