Cell Name appears - Instead result

  • Thread starter Thread starter Diana
  • Start date Start date
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.
 
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.
 
Back
Top