SUM error - displays a Date instead of SUM calculation

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

Guest

In all my rows and columns where i've put a SUM calculation for that row or column (ie as a Total), it shows a date (eg "Jan - 2003") instead of the sum of the cells.
 
Phoebe said:
In all my rows and columns where i've put a SUM calculation for that row or column (ie as a Total), it shows a date (eg "Jan - 2003") instead of the sum of the cells.
Click to expand...
Phoebe,

The cells are lost likely formatted improperly. Highlight the cells,
click on Format|Cells, on the number tab select number under category.

tim
 
Thanks Tim. An easy fix. I'm learning!

Phoebe

Tim Otero said:
Phoebe,

The cells are lost likely formatted improperly. Highlight the cells,
click on Format|Cells, on the number tab select number under category.

tim
Click to expand...
 
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

Trailing 30 days sum calculation with excel 1
Sum Formula with variable range 2
Numbers showing Up Centered in Cell ? 1
Sum using more than 6 nested IF functions 3
Copy paste data from a column to a row 0
Help with Excel Sum Function 3
Need help creating a simple (?) SUM formula! 4
Calculating Average 2

Back
Top