As I enter a date in UK format in Excel 2007 it is taken as text. The date I entered is 23/12/2009. How to get it as a date.