0.

[DanMun]

When I try to move the decimal point in a cell it leaves .0 when I'm trying to divide that cell by 2. If I don't move the decimal point when it divides by 2 it rounds up, for example dividing 13 by 2 shows 7 in the cell. Can someone help with this problem?

Thanks-
Dan

 

[davesexcel]

should the answer be 6.5?
How are you moving the decimal point?

 

[DanMun]

should the answer be 6.5?
How are you moving the decimal point?

Thanks for your response! Moving decimal point by clicking once in ribbon on top of page.

 

[DanMun]

Thanks for your response! Moving decimal point by clicking once in ribbon on top of page.

Yes Dave, the answer should be 6.5! Sorry!