In Excel 2010
when user tries to insert the cell reference to particular cell
e.g. in cell A10 of sheet1 type =sheet2!A3
it usually returns 0 (cell A3's format is text from Sheet2)
but it shows the definition of the formula "=sheet2!A3" instead of its value. I've change both cells to general but still got the same error.