Copy cell formula returns zero instead of cell value

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

Gord Dibben

In 2007 ABC123 is a cell reference.

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel mistakes cell formats 4
3 challenges; concequences of activating cell + 2 text formulaproblems 2
VBA to change format of a linked cell 1
Excel formula referencing cells 4
Formula Question 1
Extracting a Part of a Formula as Text 5
VLOOKUP returns formula instead of result 1
"Reference" to a value 4

Top