View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Office 2007 Bizarre =@sum() formula BUG - generates mailto: hyperl

@ 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