Sum formula result expressed as a date
 

I am filling in a work sheet with numbers and I am using sum formulas to
total rows. I entered a formula to add several cells to give me a total.
The Correct answer appears but it fills with a date. How can I correct this.
Thanks for your assistance

Change the format to General????

(Excel likes to help out. Sometimes it guesses wrong.)

Robert E Hansen wrote:

I am filling in a work sheet with numbers and I am using sum formulas to
total rows. I entered a formula to add several cells to give me a total.
The Correct answer appears but it fills with a date. How can I correct this.
Thanks for your assistance

--

Dave Peterson