Sum formula result expressed as a date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any ideas for this formula??? 3
Grand total sum of formula 6
Formula result showing 0 3
summing two columns of different data 4
Passing text into a formula? 8
Error when using Sum command 3
Help Writing a SUM Formula 5
Sum formulas won't calculate on fill-down 3

Back
Top