Ask Your Question

how does one avoid calc's rounding a sum (result) to 2 decimal digits?

asked 2019-02-28 23:09:21 +0100

kengra gravatar image

if I select a few cells containing data with up to 4 decimal digits, calc rounds the summation result to 2 decimal digits. this is so I can ascertain that a total is 1.0000 or 100%. when the sum is < or > than 1, I would like to know the margin of error; not the rounded to 2 decimal digit error.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-03-19 19:53:09 +0100

kengra gravatar image

thanks for your input. it caused me to find that "clear direct formatting" (what ever that means & the user guide doesn't inform) was the source of my issues. to me clear means remove, not reinitialize nor restore. in any event if used on a table cell; that revised cell starts with a paragraph indent, & number format is changed to text. if numbers are subsequently entered that "text" is rounded to 2 decimal digits!!!! hardly cleared. ken g

edit flag offensive delete link more


Yes, clear direct formatting removes applied number formats as well, hence resets the number format to the General format (which is no specific format). Specifically a number format is not set to Text, neither is a numeric input rounded to two decimals. As said, it may be displayed with less decimals if the column is too narrow to display all decimals.

And please add comments using add a comment instead of as answer which it is not (to the original question). Multiple exclamation marks don't help either. Thanks.

erAck gravatar imageerAck ( 2019-03-19 20:08:15 +0100 )edit

answered 2019-02-28 23:55:02 +0100

erAck gravatar image

If the General number format is applied (i.e. no other format like 0.00) to the SUM cell then make sure the column is wide enough to display all decimals, otherwise the decimals are rounded to the available column width. Or apply a number format with the desired amount of decimals such as 0.0000 so the result would be displayed as ### if the column is not wide enough.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-28 23:09:21 +0100

Seen: 227 times

Last updated: Mar 19