Link Format Issue

[Gary F Shelton]

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...

 

[Gord Dibben]

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

Change to General then F2 and Enter


Gord Dibben MS Excel MVP

 

[Gary F Shelton]

Thank you ... Your solution solved my problem