Hi everyone, how are youyou doing?
My problem is that I Have a colums "C"
With data of the type 1.12.17
I want to change these data to the date format 01/12/17 (dd/mm/yy)
I use a VBA code to replace all the dots with "/"
The code looks like this:
Sub ReplaceDots()
Dim i, k As String
i = "."
k = "/"
Columns("C").Replace what:=i, Replacement:=k, lookat:=xlPart, MatchCase:=False
End Sub
It works fine but the problem is, instead of getting 01/12/17 (dd/mm/yy) Spanish date Format
I get 12/01/17 (dd/mm/yy)
So December 1rst, 2017 becomes January 12rd, 2017.
Is there a way to fix this? because the column has about 3000 cells of data I can't change it manually.
Cheers,
My problem is that I Have a colums "C"
With data of the type 1.12.17
I want to change these data to the date format 01/12/17 (dd/mm/yy)
I use a VBA code to replace all the dots with "/"
The code looks like this:
Sub ReplaceDots()
Dim i, k As String
i = "."
k = "/"
Columns("C").Replace what:=i, Replacement:=k, lookat:=xlPart, MatchCase:=False
End Sub
It works fine but the problem is, instead of getting 01/12/17 (dd/mm/yy) Spanish date Format
I get 12/01/17 (dd/mm/yy)
So December 1rst, 2017 becomes January 12rd, 2017.
Is there a way to fix this? because the column has about 3000 cells of data I can't change it manually.
Cheers,