Formula shows in auto sum area instead of the total it should have added.

[John_Hill_]

When I try to add numbers together using auto sum when I hit enter to add the total the formula shows instead of the number. I contacted support and they referred me here. Help! Thanks 

[#2 · Accepted solution]

@John_Hill_ 

Do you have Formulas->Show formulas unchecked and are you sure cells are not formatted as text?

[#3]

That fixed the peoblem. Thank you!

@Sergei Baklan