Sum formula result expressed as a date

R

Robert E Hansen

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
 
D

Dave Peterson

Change the format to General????

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