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
|