Excel displays zeros as negative
by random76 - 11/30/04 10:59 AM
I have a spreadsheet where one column displays the result of a formula. For some reason, partway down this colum, Excel is displaying the zeros as -0.00 instead of just 0.00. I cannot work out why, or how to change this. Zeros display as 0.00 towards the top of the column. I am running Excel 97 on Windows XP. Does anyone have any idea as to how I can sort this out? It is messing up my conditional formatting as Excel considers -0 to be less than 0, and therefore ignores my formatting.