Sum formula not working

  • Thread starter Thread starter Monroe
  • Start date Start date
M

Monroe

Hi,
I have entered a simple sum formlua using the autosum
button and selecting a row of numbers. Instead of
getting the calculated sum when I press enter I get the
formula itself in the cell, i.e. =sum(a2:a9). Anyone
know why?

Monroe
 
Hi
if this happen only to some formulas check if the cell is not formated
as 'Text'. Goto 'Format - Cells' and change the format for example to
'General'. After this re-entr your formula

If this does not help goto 'Tools - Options - View' and uncheck
'Formulas'
 
Back
Top