Forum Discussion
Excel Crazy Horse Show
Hello again
Excel seems totaly bugged nowadays.
Example
Here is function =C145+C146
Seem fully correct
But this is the answer
#VALUE ERROR
Do I have to download Office 365 again to get rid of these problems?
🤑🙃😜
3 Replies
- Bernhard4711Copper Contributor
Hello
I have to give Microsoft an excuse. I had put the formulas in the wrong place,
Correcting that it works as expected. 🤭
/Bernhard.
That error usually isn’t because Excel is broken, it just means one of the cells you’re trying to add isn’t being recognized as a number. Even if the values look fine, one of them might contain text, a hidden space, or an extra character that causes the #VALUE! error. Try clicking on each cell and checking the formula bar for any stray spaces or apostrophes, then retype the number or change the cell format to “Number.” You can also use =VALUE(C145)+VALUE(C146) to force Excel to treat both as numbers. You don’t need to reinstall Office, it’s just a small formatting issue, not a real bug.
------------------------------------
Don't forget to mark as solution if my answer suits you- bernhardSOccasional Reader
Thanks al lot. I guess this probem have get many user irritated. I guss Microsoft know of this
problem and will deliver a software update.
Thanks a lot. 🙂