Wednesday, December 27, 2023

Google Sheets annoyances: Truncating zeros

The zeros of a decimal number in a cell are truncated by default. Hence, precision is sacrificed!

That is very annoying and patently wrong, because e.g. 1.0 or 1.000 is not the same as 1. It would perhaps be acceptable if after the third consecutive zero in the fraction was truncated, e.g. 1.12300000 would be truncated to 1.123000.

No comments: