Continuing the discussion from Format numbers to hundreds?:
I have the same issue with Calc 7.4.7.2.
Numbers are formatted with their own Style. Locale is set with “.” as thousands separator. Decimal places are set to 0. Format code is #.##0 so number zero is displayed as is.
Want to show values rounded to the hundreds, keeping internal calculations at native precision, but no combination of format I tried works. Did read the manual page “Number Format Codes”. Please advise.
The Rounding and the Formatting of the numbers are two different features. The Formatting will not round the number, and the Rounding will not format it. Use both of them if you need them.
Thanks.
Perhaps a rounded format should be added. I believe is not a common wish to compromise accuracy of calculations to improve clarity of presentation. Two different aims.
.
My tip:
Use helper cells to display the rounded values, but calculate with the accurate results. (Handle separate the “calculation” and the “report” parts of the spreadsheet.)
No other options. Thanks for the tip.
You can do it with thousands, adding at the end of the format a thousand separator.
123567 with format '#.##0.' gives 124
123567890 with format '#.##0..' gives 124
Useful with text I think: ‘ #. “thousand” ’ shows “123456" as “12 thousand”
Interesting but not what I meant.
Thanks.
Array formula facilitates: {=ROUND(R2:R8;-2}
Parenthesis missing: {=ROUND(R2:R8;-2)}