Ask Your Question

Decimal precision - how to have 18 decimals? [closed]

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

tototototototototo gravatar image

updated 2020-08-13 20:14:46 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-13 20:15:22.529655

1 Answer

Sort by » oldest newest most voted

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

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

Question Tools

1 follower


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

Seen: 915 times

Last updated: May 29 '18