You can't because there's no such date as 29/02/2006 but if you have a
real date e.g. 20060228 you can either...

..use Data Text to Columns and at step three choose date option and
YMD.

or with a formula, assuming your "date" in A1

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=517561