Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .