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

decimal
calc

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

tototototototototo
11 ●1 ●1 ●2

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

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

20859 ●19 ●60 ●59 http://etmg.altervista...

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

cloph
3496 ●11 ●25 ●60

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

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

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

add a comment

Question Tools

1 follower

Stats

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

Seen: 915 times

Last updated: May 29 '18

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

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

Question Tools

Stats

Related questions

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

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