something like this:

=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))

will convert to a standard XL date.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"denilynn" wrote:

I imported data from an industry-specific software into Excel. The 09/02/09
date, for example, converted to 20090902 in Excel. How can I change this to a
valid date format?
--
Thanks in advance for your time!
denilynn