Heya,
I'm downloading some data from the system and I need to change the formatting from dd.mm.yyyy (downloaded as text) to dd/mm/yyyy (formatted as date).
I'm using code as below, but for some reason it's swapping days and months around (dd.mm.yyyy becomes mm/dd/yyyy)
Is there any way to do it?
Thanks,![]()
Columns("H:H").Select Selection.Replace What:=".", Replacement:="/", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False
Al
Bookmarks