rae30 said:
I don't want to change my system settings for one project.
I auto filled the formula down...it seems to work for only when the day is> 12.
Because 27/06/03 is text (text if day > 12).
Try:
=IF(N(A1),DATE(YEAR(A1),DAY(A1),MONTH(A1)),DATE(2000+RIGHT(A1,2),MID(A1,4,2),LEFT(A1,2)))
It's of course better to try to fix this problem at the source or during the import.