Try this:

Copy the cell and then go to sheet 1 and do Edit = Paste Special =
select "values" and then click "OK".

HFC-SC wrote:
I am trying to copy a cell on Sheet 2 onto Sheet 1 and all I get is the
formula not the text. Help please?