help with auto sum

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

This is what I am doing:
=SUM(C69:J69) in K69
in C69 I have .10
in D69 I have 5
in J69 I have .25

K69 is giving me a total of 0.25 which is incorrect.

I have tried formatting cells to text/general and number but it still wont
add proerly.
I have also set to 2 points after decimal place.
I have used auto sum and manually typed in the formula to no avail.

Any ideas on what is wrong.

thanks
 
try this once more:

Select D69
Change the format to General (make sure it's not Text)
Then re-enter the value.

Then do the same for C69. (I'd do it for each of the cells.)

It's not enough to just reformat the cell. You have to reenter the value, too.

If that doesn't help, what is in E69:H69?
 
Thanks Dave got it working now.

One other question as I have just moved over to office 2007 and still a bit
lost with it.
I hope I warm to it as I still prefer 2003.

When I enter .10 in a cell it shows as .1
How do I get it to show as .10
 
Rightclick on the cell
Choose Format Cells
On the Number tab, choose Number with 2 decimal places.

This will actually show: 0.10

If you don't want that leading 0, you can format the cell, but choose Custom.

And type in this custom format:
..00



Thanks Dave got it working now.

One other question as I have just moved over to office 2007 and still a bit
lost with it.
I hope I warm to it as I still prefer 2003.

When I enter .10 in a cell it shows as .1
How do I get it to show as .10
Click to expand...
 
Many thanks, all sorted now.


Dave Peterson said:
Rightclick on the cell
Choose Format Cells
On the Number tab, choose Number with 2 decimal places.

This will actually show: 0.10

If you don't want that leading 0, you can format the cell, but choose
Custom.

And type in this custom format:
.00
Click to expand...
 
Back
Top