Excel can't handle Zero

Originally Posted by MrShorty

I am frequently surprised at how many programmers seem completely unaware that this is how their processor performs arithmetic. We are supposed to be the most computer literate generation, and yet we seem blissfully unaware of this most fundamental part of how a computer works.

Computer literate can mean 'good at using a computer' or 'understands how the computer works' - most people fall into the first camp. I usually try to explain FP problems by using 2/3 as a basis for some simple calculations, but allowing only three decimal places - it soon goes 'wrong' obviously... (3 x 2/3 <> 3 x 0.667).
That's before moving onto how everything in all computers is in binary, not b10, which just blows most people's minds...

@Simon Campbell, sorry to hijack your thread!