SUM error - displays a Date instead of SUM calculation

[Phoebe H]

In all my rows and columns where i've put a SUM calculation for that row or column (ie as a Total), it shows a date (eg "Jan - 2003") instead of the sum of the cells.

 

[Tim Otero]

In all my rows and columns where i've put a SUM calculation for that row or column (ie as a Total), it shows a date (eg "Jan - 2003") instead of the sum of the cells.

Phoebe,

The cells are lost likely formatted improperly. Highlight the cells,
click on Format|Cells, on the number tab select number under category.

tim

 

[Phoebe H]

Thanks Tim. An easy fix. I'm learning!

Phoebe

Phoebe,

The cells are lost likely formatted improperly. Highlight the cells,
click on Format|Cells, on the number tab select number under category.

tim