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.
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.
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
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.