Hi all,

I am importing a series of dates from a .csv file which look like "DD.MM.YYYY" (this is an export from a piece of software I do not have any power over and so is not negotiable) and I require the date format "DD/MM/YYYY". I do not know what format the dates are imported in.

To convert from one to the other I have used:

Sheets("Import").Select
Columns("D:D").Select
Selection.Replace What:=".", Replacement:="/", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Selection.NumberFormat = "dd/mm/yy;@"
Which came from the 'Record Macro' function. However, this returns correctly formatted dates if and only if the "DD" value is less than or equal to 12. I have read a few forum posts and I understand that this is because VBA defaults to US date settings - if I perform these exact changes manually I obtain the correctly formatted dates for all entries.

I would very much appreciate your help with this issue. Please let me know if I can provide any additional information.

Thanks in advance,

Josh.