Will Not Autosum

[The Animal]

I have downloaded an XL report from our accounting programme(MYOB) and trying to autosum a number of figures and is showing me in the answer cell SUM(number1,[number2],....)
I have options set on Automatic bit it will not Autosum. I can do it by manually entering a formula or by = + + + + etc but will be way faster to use Autosum
Any Advice Please
Thanks Stephen

 

[The Animal]

Any Ideas?

 

[BROWN_RY]

if your format is in text it will show just the formula you typed in. Change the format to general or number and then redu the autosum. Even if you change the format with the formulas already in as text it will not change them. let me know if that helps