Excel Date & Time

You can type in various configurations of a date and Excel will automatically recognise it as a date and upon pressing ENTER it will convert it to a date serial number and apply a date format on the cell. For example, try typing (or even copy and paste) the following dates into an empty cell: 1-1-2009 1-1-09 1/1/2009 1/1/09 1-Jan-09 1-Jan 09 ................
................