date

F

flow23

opening a CSV file into Excel.

I need to convert one column full of dates.
I tried the text to columns function.. however it only changes the date with
two digits in day ( eg. 13022005 is converted to 13/02/2005) but the dates
with single digit day ( eg. 9022005 are not converted to 9/2/2005)

any help pls
 
W

Widemonk

May not be the most efficient wany but I would use...

=DATE(RIGHT(A1,4),IF(LEN(A1)=8,MID(A1,3,2),MID(A1,2,2)),IF(LEN(A1)=8,LEFT(A1,2),LEFT(A1,1)))

(assuming your date string is in cell A1)
 
Top