='DataEntry '!K29

H

HFC-SC

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?
 
C

Chris

Try this:

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

HFC-SC

Chris.. many thanks this works.

Chris said:
Try this:

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

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
 
Top