View Single Post
  #1   Report Post  
Panama Red
 
Posts: n/a
Default Hyperlink Display problem


I had a bunch of hyperlinks set up linked to different
worksheets within the same workbook. Everything has been working fine
for months, but today I hit what I think was Ctrl plus an unknown key.
And now the hyperlinks only display the full formula, not just th text
I want. The hyperlinks still work though. I can not figure out what I
did. Any help would be great. Here is an example of the formula:

=HYPERLINK("[Groups.xls]k!a1", K!C8)
and
=K!B13


--
Panama Red
------------------------------------------------------------------------
Panama Red's Profile: http://www.excelforum.com/member.php...o&userid=26052
View this thread: http://www.excelforum.com/showthread...hreadid=393951