Dim S As String
S = Range("G2:G2000").Value
Range("G2:G2000").NumberFormat = "dd/MM/yyyy"
Range("G2:G2000").Value = S
Debug show Mismatch data.
I need to convert all data according to dates format
THis is because, VBA jumble the dates month and days
I had do as below and it was success.
Unfortunately, when i change the script as above, its failed
S = Range("G2").Value
Range("G2").NumberFormat = "dd/MM/yyyy"
Range("G2").Value = S
Please help me.