Sign in with
Sign up | Sign in
Your question

Excel 2007 Bug - Wrong Round up

Last response: in Apps General Discussion
Share
December 5, 2007 5:14:53 PM

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?
December 5, 2007 9:12:02 PM

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
December 6, 2007 12:00:47 PM

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
December 6, 2007 2:59:44 PM

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?
December 7, 2007 11:00:53 AM

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