Converting Text to Dates
 

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

Converting Text to Dates
 

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) and format the cell as Date
--
Gary''s Student - gsnu200793


"OxonLad" wrote:

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

Converting Text to Dates
 

Data Text to Columns Next Next Select Date: YMD Finish out


"OxonLad" wrote:

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

Converting Text to Dates
 

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

Converting Text to Dates
 

Here is another way to do it via a formula...

=--TEXT(A1,"0000-00-00")

Rick


"Gary''s Student" wrote in message
...
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) and format the cell as Date
--
Gary''s Student - gsnu200793


"OxonLad" wrote:

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