Forum Discussion
Shortcut problem
Hello I have the most strange problem with execel summary funcition 800,00 Summaru 800,00 This is correct. -99,00 -275,00 0,00 800,00 0,00 And this is wrong...
Some cells aren’t true numbers — likely text or contain hidden characters (NBSP or a Unicode minus).
Fix:
Test with =ISNUMBER(A1) — if FALSE, it’s text.
Select the cells → Data → Text to Columns → Finish or Paste Special → Multiply by 1 to convert to numbers.
If still wrong, strip spaces: =VALUE(SUBSTITUTE(A1,CHAR(160),"")).
Then SUM will work correctly.