Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You can't. LibreOffice uses IEEE 754 representation of the numbers, and that just doesn't offer that level of precision.

see also https://ask.libreoffice.org/en/question/111735/column-has-been-defined-as-a-decimal-type-the-max-length-is-19-characters-with-15-decimal-places/

and general description of the way precision works in IEEE 754 here: https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel

If you want to store the values in a spreadsheet, you have to do so as text (enter them by prefixing them with a single quotation mark, that will force the input to text)