Do those steps in Excel with the macro recorder on, that will supply the
code.

--
__________________________________
HTH

Bob

"Arne Hegefors" wrote in message
...
Hi! I often import data from other programs to Excel and often the date
formats of those files is of a type that Excel does not understand.
Normally
they look like this 12/31/2012 (ie mm/dd/yyyy). now i want to be able to
convert these dates to excel readable dates. i can do this choosing text
to
columns and then do some stuff but that takes some time if there are many
series. Is there any way I can write a macro that does this for me? any
idea
on how to do that? Thanks alot for your help!