I don't know if it's a bug--or a feature. It's a fine line <vbg.

If you don't want to stop using that @ in your functions, how about hitting
ctrl-z (edit|Undo) right after it's turned into a hyperlink?



funnybroad wrote:

Correct me if I'm wrong, but isn't it still a bug, since =@whatever isn't a
valid internet email address anyway?

"Dave Peterson" wrote:

@ 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)

funnybroad wrote:

Using =@sum(a1:a3) or any formula will automatically generate an EMAIL
hyperlink.

We also use Infopath. When you are in a rich text format control, and you
type =@sum(a1:a3) and hit enter after the closing paragraph character, it
generates a mailto: hyperlink.

--

Dave Peterson


--

Dave Peterson