Link Format Issue
 

I have two worksheets: We will call them Data and Result. On the result
worksheet I have been linking back to the data worksheet for some data. Now
all of the sudden on row one hundred any time I try and link back to the
other worksheet I get the linked formula displayig on the computer screen.
Why or more important how do I get it off the screen...

NOTE: CTRL+~ key did not remove it off my screen...

--
GS

Link Format Issue
 

Sounds like the cell was pre-formatted a s Text.

Change to General then F2 and Enter


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 09:29:02 -0800, Gary F Shelton
wrote:

I have two worksheets: We will call them Data and Result. On the result
worksheet I have been linking back to the data worksheet for some data. Now
all of the sudden on row one hundred any time I try and link back to the
other worksheet I get the linked formula displayig on the computer screen.
Why or more important how do I get it off the screen...

NOTE: CTRL+~ key did not remove it off my screen...

Link Format Issue
 

Thank you ... Your solution solved my problem
--
GS


"Gord Dibben" wrote:

Sounds like the cell was pre-formatted a s Text.

Change to General then F2 and Enter


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 09:29:02 -0800, Gary F Shelton
wrote:

I have two worksheets: We will call them Data and Result. On the result
worksheet I have been linking back to the data worksheet for some data. Now
all of the sudden on row one hundred any time I try and link back to the
other worksheet I get the linked formula displayig on the computer screen.
Why or more important how do I get it off the screen...

NOTE: CTRL+~ key did not remove it off my screen...