Ask Your Question

Decimal precision - how to have 18 decimals?

asked 2018-05-29 19:27:28 +0200

tototototototototo gravatar image

Hello, I am inputting numbers that have 18 decimals. For example : 0.041345058938493747

Default settings seem to round up this number and save it as: 0.0413450589384938

I have tried to use the Format... dialog to increase precision, but it still rounds it up to 16 decimals: 0.041345058938493800

So...? How do I increase precision? Thanks in advance!!!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-05-29 20:11:47 +0200

cloph gravatar image

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

see also

and general description of the way precision works in IEEE 754 here:

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)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-29 19:27:28 +0200

Seen: 268 times

Last updated: May 29 '18