Originally Posted by macropod

I confirmed the correct behaviour with Excel 2010 before posting. Correctly installed, Excel 2010 works as specified. If you're not getting the correct results, that suggests your installation(s) are at fault, regardless of how many you might claim to have tested with - or that you're not telling us the whole story...