https://bugs.documentfoundation.org/show_bug.cgi?id=152039
--- Comment #4 from Jonny Grant <j...@jguk.org> --- Maybe it's just an English thing, we're taught as follows in formal education https://thirdspacelearning.com/gcse-maths/number/decimal-places/#:~:text=re%20still%20stuck.-,What%20are%20decimal%20places%3F,the%20right%20of%20that%20number. I know other countries may have different understandings, some even use different separators (dot instead of comma etc) May I check if you read the "Format cells" dialog? "decimal places" refers to the number of decimal places after the dot. If I set 3 decimal places on that dialog it does show the format code: #.000 Then my number I enter as: 1.0012 Only shows 1.001 So it seems accurate? Anyway, without going over floating point. Why not truncate the output two 2 decimals after the dot? The rest can be displayed as 0 because it's obvious in decimal arithmetic they will never be anything else even if I set 15 decimal places after the dot. -- You are receiving this mail because: You are the assignee for the bug.
