change date format to excel format

M

Motta

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

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)
 
Top