Why is it that when I link a cell to one from another worksheet,
 

The value isn't shown, the formula is??

Why is it that when I link a cell to one from another worksheet,
 

A little more info on this -I'm doing the usual '=' then clicking on the cell
I want the value of, which has worked previously in this spreadsheet. The
first time I've tried to link from a new worksheet (8th worksheet) it's
showing ='February 08'!E3 instead of the value.

"kymposs" wrote:

The value isn't shown, the formula is??

Why is it that when I link a cell to one from another worksheet,
 

"kymposs" wrote:
Why is it that when I link a cell to one from another worksheet,
The value isn't shown, the formula is??

One guess - that particular cell was earlier formatted as TEXT (unknown to
you of course). Just re-format as general or number, then either re-do the
link or re-activate the link formula by clicking inside the formula bar &
pressing ENTER. You need to re-trigger the formula, just re-formatting the
cell alone won't activate it.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Why is it that when I link a cell to one from another workshee
 

Thanks Max. Just before I read your reply, I looked at the formatting &
realised. 'blonde day'

"Max" wrote:

"kymposs" wrote:
Why is it that when I link a cell to one from another worksheet,
The value isn't shown, the formula is??

One guess - that particular cell was earlier formatted as TEXT (unknown to
you of course). Just re-format as general or number, then either re-do the
link or re-activate the link formula by clicking inside the formula bar &
pressing ENTER. You need to re-trigger the formula, just re-formatting the
cell alone won't activate it.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Why is it that when I link a cell to one from another workshee
 

Ahh, no prob there.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"kymposs" wrote in message
...
Thanks Max. Just before I read your reply, I looked at the formatting &
realised. 'blonde day'