Forum Discussion

Panonra7660's avatar
Panonra7660
Copper Contributor
Feb 17, 2021

Berechnung Summe ist immer "Null" Excel on Mac

In meiner Tabelle steht bei der Berechnung der Summe immer 0,00 - was kann ich machen - Format ist auf "Zahl" gestellt

4 Replies

  • Panonra7660 

    Perhaps Excel sees the values as text even though the cells are formatted as numbers.

    Things to try:

    • Select a column with such values. On the Data tab of the ribbon, click Text to Columns, then click Finish.
    • Alternatively, select an empty cell and copy it. Then select a range with values that won't sum. Click the lower half of the Paste button and select Paste Special...
      Select Add, then click OK.

Resources