Spreadsheet will not return value of formula

[jmadden35]

I have a spreadsheet that will not return the value of a formula. It
only states the formula.
If I have say a column of numbers A1 to A6 and put the formula
=sum(Aa1:Aa6) in A7 all that appears in A7 is the typed in formula not
the actual sum. If I copy the column of numbers to another sheet in the
workbook and put in the same formula I get back the actual sum????

 

[Ed]

In the offending workbook, check Tools >> Options, View tab, Window options
section, uncheck Formulas box.

Ed

 

[Guest]

Is it possible you've formatted that cell as text?

A Jones

 

[jmadden35]

In the offending workbook, check Tools >> Options, View tab, Window options
section, uncheck Formulas box.

Ed

Thanks Ed that was the answer. Funny thing though, If I inserted a new
sheet into the
workbook that sheet did'nt have the problem??

 

[Gord Dibben]

That would be normal.

That setting is a Sheet setting, not a workbook or global setting.


Gord Dibben MS Excel MVP