I have this annoying problem that I can't figure out the cause of, here is what I did:

1.I did a very simply auto sum function for a couple of columns

2.under advanced options I deselected "use system separators" and under "decimal separator" I put comma instead of default dot because when I copypaste numbers from internet they mostly use commas so if it is any other it won't autosum at all and then I would have to manually replace dot with comma for each number. So it's just a convenience.

3. I formatted the autosum cell so it displays my preferred currency, set the decimal places to 2 and clicked OK
but that OK did nothing, when I open the formatting cell again it says 5 decimal places, it simply reverts to 5 every single time, and if I put decimal place to 0 it reverts back to 3.

4.so instead of getting correctly formatted number like 1441,75 I always get stupidly formatted number 1441,750,00


Why does it keep doing that, it doesn't make any sense!