How to stop OpenOffice Calc from rounding numbers

openofficeopenoffice-calc

I have a cell which contains a formula "=A1/A2" and I just want it to truncate the number after two decimal places instead of rounding it off.

How do you stop Open Office Calc from automatically rounding numbers?

Best Answer

The numbers are rounded merely for display purposes. That is, if the value in the cell (for example) equals 23.104999, and you have formatted that cell to display only the first two decimal places, then the cell will show the value of 23.10 - but still, the actual value in the cell would be 23.104999. Multiplying the value of this cell by 2 would result in 46.21 (not 46.20). I think you get the idea.

To change the number of decimal places shown, simply select some cells, and press right mouse button, then select Format.

If you need to actually round / truncate the number and keep the truncated value in a cell, take a look at OpenOffice's TRUNC function. You might also want to look into other similar functions (FLOOR, CEILING, ROUND).

Related Question