Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003 - don't want hyperlink with @sum()
When I type a formula like )" 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 :) |
#2
|
|||
|
|||
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" wrote in message ... When I type a formula like )" 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 :) |
#3
|
|||
|
|||
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" wrote in message .. . When I type a formula like )" 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 :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 performance problems | Excel Discussion (Misc queries) | |||
Help in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2003 V's Excel 2000? | Excel Worksheet Functions | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) |