Data/ Text to Colums/ Delimited/ Next/ Next/ Date : YMD
--
David Biddulph

"OxonLad" wrote in message
...
Some of our company systems output dates in the format yyyymmdd but in a
"general" format eg 20080625 for the 25th June 2008. How can I convert
this
to a date so I can use the day(), month(), year() functions?

At the moment I am using left(), mid(), right() to break up the text
string
but there must be an easier way

Thank You