Forum Discussion

Bernhard4711's avatar
Bernhard4711
Copper Contributor
Oct 08, 2025

Shortcut problem

Hello

I have the most strange problem with execel summary funcition

 800,00
Summaru800,00

 

This is correct.

-99,00
-275,00
0,00
800,00
0,00

And this is wrong. The sumfunction covers all the 4 numbers above and the numbers are formatted as numbers.

Any idea?

Regards

Bernhard

excel

1 Reply

  • Nilson_'s avatar
    Nilson_
    Occasional Reader
    Oct 08, 2025

     

    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.

Resources