='DataEntry '!K29

[Guest]

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?

 

[Chris]

Try this:

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

 

[Guest]

Chris.. many thanks this works.

Try this:

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

 

[Gord Dibben]

Perhaps the Sheet1 cell is formatted as text?

Re-format to General and re-enter the formula by F2 then Enter.


Gord Dibben MS Excel MVP