Hi Simon,

unfortunately the date fields are set as data type Decimal, so it won't
let
me pull it apart with substing or the others...

Hmnn...

What version of SQL Server and Excel are you using?

I built a small table in SQL Server 2005, with a Decimal data type field
containing dates in your format. Then I used Excel 2003 to run MS Query and
parsed the field as shown. Worked well for me.

Ed Ferrero
www.edferrero.com