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

New Contributor

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 Replies
best response confirmed by Hans Vogelaar (MVP)


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