Recently I helped someone who was having trouble entering data in a new installation of Excel 2007. When he entered 100, the value was automatically changed to 1. If he typed 1000, the value immediately became 10. Very mysterious, and frustrating for the user.

It's a Feature

What the user had discovered was a relatively [...]