ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlinks in Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/4146-hyperlinks-formulas.html)

Smookieman

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.

Gord Dibben

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.




All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com