Please Hep!

Imported a XML file into MS Excel 2003, the file contains dates expressed as a numbers i.e 20091225. I'm trying to convert this number in excel into a date, so I can eventually aggregate by day of week.

Example:
20091225 covert to 2009/12/25