edit: Here's an example - I recently got done teaching a data basics class, and inevitably, my students ran into the problem of data typing in Excel...you type in something like "9/14" into a field, and it treats it like a date, and moreover, displays it as "Sep-14". But when you try to concatenate the field, or perform some other kind of operation on it that is not date-related, Excel treats it as an integer (number of days since 1904, or something like that).
So Microsoft has arguably done something user-friendly here...virtually anyone who types in '9/14' probably means September 14, 2013. However, this isn't always the case, and if it isn't, you have to know how to format columns in Excel as text. Moreover, the operations upon date types are not at all intuitive. If you've done a minimal level of programming, you get the idea of data types, including dates and strings. Let's pretend Microsoft comes up with a way to perfectly guess what you mean when you've typed in a value...is it possible this will eliminate the need for the average user to have an understanding of data types in order to do non-trivial work?