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.

Click to download the file.

Leave a Reply