date format

[Forestq]

Hi,

in csv file I have column, where are date's with diffrent format as below:

02/03/2014 00:10
1/02/2014 7:25:00
7/03/2013 8:30:00 PM

I want to set up the same format for all date's.

I`m doing something like:

With WS

LastRow = WS.Cells(WS.Rows.Count, "A").End(xlUp).Row
 .Range("T" & LastRow).Selection.NumberFormat = "dd/mm/yyyy hh:mm:ss"

End With

but is going wrong.

Any idea how to do it?

 

[exceldevs]

Hi Forestq,

Your code only works on the last used cell in column T, are you looking for something like this? (ps: code not tested)

WS.RANGE("T1:T" & RANGE("A"&ROWS.COUNT).END(xlUp).Row).NumberFormat = "dd/mm/yyyy hh:mm:ss"[COLOR=#222222][FONT=Verdana]

[/FONT][/COLOR]</pre>

 

[Forestq]

works ok, but in csv date has custom format: dd/mm/yyyy hh:mm

while is displaying dd/mm/yyyy hh:mm:ss

 

[exceldevs]

I don't think I could understand your issue well, could you put up sample table with expected result?

 

[Forestq]

nevermind, thanks for help!

 

[exceldevs]

You're welcome, hope you get it fixed.