Sum not working

[ShaunAldridge]

Hi,

I have an issue whilst summing and it's really making my brain hurt. I hope someone can help me please!

I have a list of numbers that are all rounded to 2dp, which I have confirmed by selecting each cell and checking each value. The total of the values is 8579.52 which the sum function gives correctly in the cell that it's calculated in. BUT, when I paste values of the total it gives 8579.51999999999. I cant for the life of me figure out which value isn't rounding to 2dp correctly. The same thing happens if I use a sumif but it seems to work correctly if I sum half of the values, then the other half and add them together!


Does anyone have any ideas? I'm trying to import a csv to our accounting system and it is rejecting it because I guess it can see that one of the values isn't rounded correctly.

Thanks,

Shaun

 

[Alex Blakenburg]

Shaun, have actually opened the csv file sent to the accounting system in Notepad ?
Is everything showing 2 decimals places when opened in Notepad ?
If yes, your problem is unlikely to be a rounding problem.
I need to see the csv upload file not an excel file.
At a bare minimum the top 5 and last 5 previously requested.

Also you are indicating there is only one column and the items are all positive, is there no negative ? Dr+Cr = 0 ?