Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have two columns which have been summed. When I sum the two cells with those results, openoffice rounds the sum every time. If I only enter two numbers and then sum them, it operates normally. Anyone have this problem or any suggestions? Everything is formatted as number with two decimal places and I never extend the numbers longer than two decimal places.

share|improve this question

1 Answer 1

The rounding is not happening in the arithmetic, it is happening in the presentation of the result. Change the format of the cell having the formula to show more precision in the presented result. It may be that the format of the cell where you made the sum did not get set to numeric with two decimal places.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.