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
Formula fill series? 1
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Return BLANK is cell value sought is blank 13
Extracting a Part of a Formula as Text 5
Can you display entire rows that match a certain criteria... 1
Excel formula referencing cells 4
VLOOKUP returns formula instead of result 1

Top