I am having trouble entering dates in 2007. Under 2003, I only had to type in the day and the month, hit the enter key, and the date would complete itself with the year. In other words, for today's date, I would enter '20/12', press enter, and the date would come up as '20/12/09' or '20 December 2009' automatically, depending on how I had it formatted. This does not happen in 2007. All I get in the cell is exactly what I enter. Can 2007 auto-complete dates like 2003 could?