Hi All

I have a workbook where I import over a thousand rows of data into that I need to filter through. The data I import has the correct date format that I need ( dd/mm/yyyy ). 2 of the columns are purely dates in the worksheet but when I run my macro which hides columns and adds cond format etc to save time it throws the date into mm/dd/yyyy


Is there any way I can change this. Look forward to a top draw response as always from this forum


Miff3436