View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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