ndmmxiaomayi SG Cute bug there. If the figure is somewhere near 65536, it will screw up and give you an odd answer. Those who have Excel 2007 can try it out. http://ap.google.com/article/ALeqM5j7HWSNLp5sHqZDXPrYNSgDZcddnAD8RUIGB80 http://blogs.msdn.com/excel/
venny SG doesnt seem to affect my excel 2000. this reminds me of the old pentium floating point bug.....
ndmmxiaomayi SG Maybe. But surprisingly, it only happens to the number 65536. Other numbers turn out OK.
ndmmxiaomayi SG Huh? Did you just type in those figures? Do some calculations of figures that are near 65536. Like 10.0 X 6553.6
ndmmxiaomayi SG Heh, weird. Vista no problems? How about trying some of the calculations in the AP article?
wishboy SG lol wth... 16,383.75 * 4 excel gives the answer in 2 d.p. , somemore got comma ok the calculation in the AP article are the only ones with bug i think
kenn3th SG who have microsoft office 2007 home and student ect (cannot enterprise) can be a good soul help me pm me for more details
ndmmxiaomayi SG http://www.downloadsquad.com/2007/10/10/microsoft-fixes-excel-2007-calculation-bug/ Fixed.
