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.
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.