Oops... 9/25/2007 7:24:00 AM
Note to self: If I ever find a time machine, send this list to the Excel 2007 team before they ship.


+ Comment
Dave Wow that's a good one. I thought this would just be demonstrations of floating point math producing results inconsistent with real math. But how do you accidentally get 100000 instead of 65535? Granted 65535 is a special number but where does 100000 come from? Try '=65535*2/2' and '=65535*2.1/2.1'
Dave Err... 1.1 not 2.1 above
Chris Hmmm, they (http://blogs.msdn.com/excel/) say its a display issue and the calculation is really working on the backend.
Eric Phew, that's a relief. It just ~looks~ like a bug. :-)

< Eric's Blog Home

©1998-2023 Eric Lawrence