help with auto sum

[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

 

[Dave Peterson]

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?

 

[SS]

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

 

[Dave Peterson]

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

 

[SS]

Many thanks, all sorted now.

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