Sum Function Problem!!

M

md

I have created a worksheet with dates going down the left hand side and
various numbers on the right. There is a clear column between the two. I want
to use the sum function to add up the numbers on the right, but when I do the
answer is a date, not the sum of the answers!?!

Any ideas gratefully received!!
 
K

kassie

The cell you are using was previously formatted as a date. Format the cell
as a number >> Format|Cells|Number
 
Top