I have a problem regarding the SUM-function. It doesn't seem to be able to correctly sum the numbers put in a sheet.
I guess it has to do with some sort of formatting, but I genuinely have tried to format it to the best of my knowledge.
I have put in all the numbers manually using 3 decimals for each cell, still the sum seems to think it has 16 decimals!
All the cells have the same format. How is this possible?
[TABLE="width: 335"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,630000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,510000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1,600000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]55,300000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]-63,152000000000000000000000000000[/TD]
[/TR]
[TR]
[TD]SUM:[/TD]
[TD="align: right"]0,087999999999993900000000000000[/TD]
[/TR]
</tbody>[/TABLE]
I guess it has to do with some sort of formatting, but I genuinely have tried to format it to the best of my knowledge.
I have put in all the numbers manually using 3 decimals for each cell, still the sum seems to think it has 16 decimals!
All the cells have the same format. How is this possible?

[TABLE="width: 335"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,630000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,510000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0,520000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1,600000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]55,300000000000000000000000000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]-63,152000000000000000000000000000[/TD]
[/TR]
[TR]
[TD]SUM:[/TD]
[TD="align: right"]0,087999999999993900000000000000[/TD]
[/TR]
</tbody>[/TABLE]