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

On Wed, 9 Aug 2006 12:29:02 -0700, 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?