G Guest Aug 9, 2006 #1 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?
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 Aug 9, 2006 #2 Try this: Copy the cell and then go to sheet 1 and do Edit => Paste Special => select "values" and then click "OK".
Try this: Copy the cell and then go to sheet 1 and do Edit => Paste Special => select "values" and then click "OK".
G Guest Aug 9, 2006 #3 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...
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 Aug 9, 2006 #4 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
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
