Copy cell formula returns zero instead of cell value

  • Thread starter Thread starter Dorci
  • Start date Start date
D

Dorci

Excel 2007: Example
Sheet1 - Cell A1 = ABC123 (formatted General)
Sheet2 - Cell B2 has formula ='Sheet1'!A1 (formatted General)

The result of the formula in B2 is 0 instead of ABC123. I've tried changing the format of both the source cell and the destination cell with no success. The result is either 0 or the formula string "='Sheet1'!A1". This should be so simple. I've been using Excel for decades and have never had this problem. What am I doing wrong?! Thanks in advance for your help.
 
In 2007 ABC123 is a cell reference.

Are you sure you don't have an INDIRECT in your formula?


Gord Dibben MS Excel MVP
 
Back
Top