Amount (Credit) Amount (Debit) 4921022 73312 5414982.79 34605326.69 451357 119988372.7 12652309.31 2710307 154609656.9

Have you tried rounding it to 2 decimals using the round function? Just to make sure there's no hidden decimals. Sometimes I just see 2 decimals but when I click the cell, there's actually more numbers

I've also caught Excel truncating before when saving to CSV. Like if I have 12.23 in a cell, but it's for some reason displaying 12.2, when you save as CSV, it will save it as 12.2. I was pulling my hair out trying to figure out wtf was happening. Never figured out why it was not showing the second decimal place in the first place. Probably something screwy with my data source.