Just to add some more explanation. I get an excel file every week i
which I have a column (column I) and the date is in this format, s
eventually I'm going to have to figure out a way to loop this up th
column through the rows to change the date formats

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=51692