replace "." with "/"
hi there again,
i am trying to replace a"." with a"/" in column A, i have used the recorder and it gave me this code:
Selection.Replace What:=".", Replacement:="/", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
when i use the code in a macro the code moves some of my values around (it is dates in column a)
for example if i have "11.07.05" in some cases it returns "07/11/05"
any help would be great guys thanks
|