Forum Discussion
Excel Crazy Horse Show
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
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. 🙂