change date format to excel format

[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?

 

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