Excel 2007 Bug - Wrong Round up

[yeungl]

librayeung.com/excelwrong.xlsx

Please check on the grey cell. It has to be in percentage. But when you adjust the decimal place, it will not round up. And anyone verify it?

 

[g-paw]

I'd be surprised if anyone will download that file, downloading files is just too dangerous. I'd start with checking the formating of the cell, especially the numerical settings

 

[yeungl]

This a worksheet I am working on@ my walk place. Please take a look, there is no macro, jsut a few table and the round down problem bother me. Therefore, anyone please help

 

[g-paw]

I don't have Excel 2007 so someone else would have to check. Have you checked the numerical settings for the cell, e.g., how many decimal points you have?

 

[yeungl]

2 or 3 d.p.
you can use compatibility package, so that you can read 2007 format