Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

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

Copper 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)
Solution

@John_Hill_ 

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

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@John_Hill_ 

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

View solution in original post