M Motta Mar 11, 2010 #1 Hi, I have a date in 01.03.2010 format, how can I change it by using vba for every time I import the data?
Hi, I have a date in 01.03.2010 format, how can I change it by using vba for every time I import the data?
B Bob Phillips Mar 11, 2010 #2 You can use Data>Text To Columns and use the last tab to set dates. I just recorded a macro to do it, and after tidying it left Columns("O:O").TextToColumns _ Destination:=Range("O1"), _ DataType:=xlDelimited, _ FieldInfo:=Array(1, 4)
You can use Data>Text To Columns and use the last tab to set dates. I just recorded a macro to do it, and after tidying it left Columns("O:O").TextToColumns _ Destination:=Range("O1"), _ DataType:=xlDelimited, _ FieldInfo:=Array(1, 4)
