If you can see the results of other formulae on the sheet, the chances are
that your cell is formatted as text. Format as General & re-enter the
formula.
--
David Biddulph

"Zac" wrote in message
...
I am trying to link a cell in one worksheet (sheet 1) to a cell in another
worksheet (sheet 2). I put in = then click on sheet 1 tab, then click on
the
cell I want to link and press enter. The result puts me in sheet 2 in the
cell I want but with the formula ='sheet 1'!A1 instead of the text that is
in
that cell. How do I get it to show the text from cell A1 sheet1 instead
of
the formula?