Overcoming common problems - Date

Getting wrong date formats when entering a date? Let's say you entered 1st April 2010 in excel, but upon pressing the Enter key the date shows 4th January 2010 instead. This is because the window setup for dates is in the American date sytle. To correct this, go to the control panel and change the date setting to dd/mm/yy ie day/month/year format.