No, but you can convert it with a formula.

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

Format as desired.
--
Best Regards,

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


"Pimamedic" wrote:

How do I convert 20090228 to read as 02/28/2009 is there a format to do
this?? TY