I have a simple spreadsheet with a few floating point numbers. All two decimal places or less. The total of the numbers is zero. But Excel displays the total as 2.32832E-11 (which is nearly zero but I’d rather just see a zero).
It does resolve itself if I change the format of the Column from General to Number but it is annoying to have to do that.