Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
@ 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Migrating Office XP EXCEL files to Office 2007 | Setting up and Configuration of Excel | |||
Office 2007 Pro Plus 2007 (Beta) - getting small red and green arr | Excel Discussion (Misc queries) | |||
Performance not upto Office 2003 standards in Office 2007 | Excel Discussion (Misc queries) | |||
Batch create hyperl formula from hyperl value | Excel Discussion (Misc queries) | |||
PPMT formula that generates equal payments | Excel Worksheet Functions |