Forum Discussion
John_Hill_
Jul 18, 2022Copper Contributor
Formula shows in auto sum area instead of the total it should have added.
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
Do you have Formulas->Show formulas unchecked and are you sure cells are not formatted as text?
2 Replies
- SergeiBaklanDiamond Contributor
Do you have Formulas->Show formulas unchecked and are you sure cells are not formatted as text?
- John_Hill_Copper Contributor
That fixed the peoblem. Thank you!