I have downloaded a multi-row csv file which uses the following date format on each row:

04.01.2013 00:00:00.000
This is a UK-style date which I want to convert to a simple US date in this format: 01/04/2013

I've tried using "substitute" and "clean" to get a standard date which excel recognizes, but I'm only partially successful. One trick I've used in the past is to use "left" and "substitute" in order to get 04/01/2013. Sometimes I've used *1 which helps get it into a true number. But once the date hits 10/01/2013, excel no longer sees it as a date.

Any advice?
Thanks!