formating a date

[Jim]

Hello,

When I pull data the dates came over looking like this:
1090325

This represents March 25, 2009. All of the dates have the 1 in front of
them. How do I eliminate the "1" and show a proper date?

Thanks

 

[Gary''s Student]

With your value in A1, in another cell use:

=DATE(MID(A1,2,2)+2000,MID(A1,4,2),RIGHT(A1,2))