satyen
10-05-2008, 06:15 AM
hello,
Ive tried a number of ways and different codes, but nothing seems to work.
I am trying to format different date formats in a column so that they are ALL uniform i.e. dd/mm/yyyy (english, united kingdom)
I even recorded a macro and this is the code
Columns("A:A").Select
Selection.Copy
Range("C1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlAdd, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Selection.NumberFormat = "dd/mm/yyyy;@"
sample dates are:
12/05/08 12:23:06
05/05/2008 13:14:08
10-May-08
13/05/08
09-May-2008
Please note: some date will have times with them. The xl. sheet needs to be converted to a csv file after
Please can someone help?
Many Thanks.
Ive tried a number of ways and different codes, but nothing seems to work.
I am trying to format different date formats in a column so that they are ALL uniform i.e. dd/mm/yyyy (english, united kingdom)
I even recorded a macro and this is the code
Columns("A:A").Select
Selection.Copy
Range("C1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlAdd, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Selection.NumberFormat = "dd/mm/yyyy;@"
sample dates are:
12/05/08 12:23:06
05/05/2008 13:14:08
10-May-08
13/05/08
09-May-2008
Please note: some date will have times with them. The xl. sheet needs to be converted to a csv file after
Please can someone help?
Many Thanks.