Hello,
I can’t disable automatic rounding off decimals like from 0.00021 to 21. I tried in tools/options/calculate to check “precision as show” or “limit decimals for general number format” and increase size of numbers - didn’t work! I didn’t notice any function would be off for a cell, but I can’t even tell so…
How do I disable this for whole document? Or cltr+a is also fine… Simplest way…
Thanks!
What are you talking of? Nothing rounds 0.00021 to 21, so what exactly do you mean?
Yet it happens 
I have some number like 0.00011 and it rounds to whole number 11.
Have you possibly not entered the decimal separator correctly or not at all?
Check your input at the top of the input line.
No it didn’t work, i thought previously as i misplaced dot with a dash. But using dot - number instead reverts to 0. Can i somehow remove all styles from doc? All that could cause trouble I don’t need anything there, except keep links mb.
Which operating system and which LibreOffice version do you use?
In which file format do you save?
And please upload here a reduced and anonymized file in which the problem is present.
To do this, click on the three dots or the pencil or the edit icon under the initial question. What is available.
In the edit mode of the question select the “Upload” icon.
Select your file and click the “Upload” button.
Thank you very much.
Numbers.Windows 10, Libre 7.4.0.3, .ods, but was happening even in xsls or something…
Honestly it is just from I written after number (per 1g) I think, as if I remove than click elsewhere, than go back and delete cell and write only number (as it switches to whole number after that) it is fine.
I tried find all and replace all, but it didn’t work, doc is not that big so I care I will just edit these out, thanks for help. I don’t have strength to solving annoying things ATM…
Oh it still bugs out in same doc even after all that, but if i paste it to another, it at least works like this…
Are you using the same decimal separator as set for your language in Tools - Options - Language Settings - Language?
If you are using a thousands separator where you want to place a decimal separator then you could get the same effect
And now it doesn’t work… OK Let me check!
EDIT: Oh I already talked about this… Both when i write dot, or dash it bugs in specific way as I mentioned…
Lol you have it opposite I said from 0.00021 to 21, no offense just in case 
Just to repeat: and using dash reverts to 0 - how strange! To also add, i copy-paste this from google sheets, as issue started happening there and I couldn’t remove style…
Hope this suffices!
Omega contents in a food - Copy.ods (25.3 KB)
Also here is whole doc to not forget, nothing sensitive you can have it
Why mention dash? there isn’t a locale using a dash as decimal separator. But silly (and explicitly deprecated!) number formats use the dot as a “thousands separator” if the decimal separator is the comma, and vice versa.
Learn how to look for the Numbers formatting of cells, and how to select or define a reasonable one.
To the format dialog for selected cells you get using the context menu e.g. (rightclick)…
Don’t omit reading of manuals completely.
Clicking on cell C23 in your sample file, and selecting Menu → Format → Cells, then changing the number of decimal places to 5, produces the desired 0.00021. Does that solve your problem?
Also it is noticed that a number of cells in column D use a “.” as the decimal indicator, while a number of others are using “,” instead. The same is happening in column C. It seems that there are mixed locales, which will probably produce confusion.
Problem is if i change number of decimal places, it will add 0000 after numbers as any number has different amount of decimal places… And changing this one by one would take forever. I fixed everything to dots, but still from c26 - when i removed (per 1g), it changes to 0. Not sure if this could interfere! But then even if i ctrl+a cell and press delete and rewrite number it changes to 0 again. I don’t know if there are some styles or something applied, how would i delete. I have chronic pain not sure if i mentioned, it is even hard to read anc compherend what you are saying…
PS: I don’t know anything about office, i found it always so annoying to use and completely bugged and counter-intuitive, i am very intuitive. Basically every document i wrote, at some point completely broken even if i avoid using hotkeys… It is hard to see if there is something set somewhere…
EDIT: wait cltr+m on cell worked, i tried this before and it didn’t work for some reason then… as at the top field there is correct value when it shows 0.
