Cell Name appears - Instead result

D

Diana

I'm trying to make a summary page from other sheets in the same book.

I Have in one cell:
='1'!Q19
And appears 6 wich is Ok!

The next cell is:
='1'!L21

And I get ='1'!L21 Never the number that is in L21 Page 1.

Can somebody help me? It happend in couple cells... some are good, some are
wrong.

Thanks...

Diana P.
 
S

ShaneDevenshire

Hi,

Most likely that cell is formatted as text. Select the cell, choose Format,
Cells, Number tab, set the format to General and click OK.
Now reenter the formula.
 
Top