| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Hyperlinks in Formulas
When ever I use the '@sum' formula, the answer comes up as a hyperlink. This
is annoying - is there a way to disable this. I just want the answer to show, not a hyperlink. |
|
#2
|
|||
|
|||
|
Don't use the Lotus @SUM
Use the Excel =SUM() OR ToolsAutocorrect OptionsAutoformat as you typeReplace as you type. Uncheck "Internet and network paths with hyperlinks" Gord Dibben Excel MVP On Tue, 18 Jan 2005 15:49:03 -0800, "Smookieman" wrote: When ever I use the '@sum' formula, the answer comes up as a hyperlink. This is annoying - is there a way to disable this. I just want the answer to show, not a hyperlink. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas not working | Excel Discussion (Misc queries) | |||
| Hyperlinks static but formulas are not. Why? | Excel Discussion (Misc queries) | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| Why won't formulas obey vertical alignment commands? | Excel Discussion (Misc queries) | |||
Hybrid Mode
