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

On Tue, 8 Mar 2011 08:26:18 -0800 (PST), Dorci <(E-Mail Removed)>
wrote:

>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.