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
- Jul 18, 2022
Do you have Formulas->Show formulas unchecked and are you sure cells are not formatted as text?
SergeiBaklan
Jul 18, 2022Diamond Contributor
Do you have Formulas->Show formulas unchecked and are you sure cells are not formatted as text?
John_Hill_
Jul 18, 2022Copper Contributor
That fixed the peoblem. Thank you!