Hyperlinks in Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Don't use the Lotus @SUM

Use the Excel =SUM()

OR Tools>Autocorrect Options>Autoformat as you type>Replace as you type.
Uncheck "Internet and network paths with hyperlinks"


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open specific hyperlink (accept) automatically in email with outlook 0
hyperlink to cell based on formula results 4
Will not auto open .jpg 1
vlookup with hyperlink in formula 3
make Hyperlink jump on the top row 2
Autofill hyperlinks 5
Activating hyperlinks 3
Jeopardy on Powerpoint 0

Back
Top