You seem to be using US regional settings but the date text is in UK format.
Hence excel cannot convert it automatically into a date. The solution is to
switch your regional settings to English(United Kingdom) then do the Text to
columns changes and after completing the macro, save and close the workbook
and switch back to whatever your original regional setting was. Then open
your workbook and all dates should be OK.

Alok Joshi

"Nortos" wrote:

I've been trying to record a Macro so that I can change text in columns to a
date format, I've used Text to columns to do this which works well outside a
Macro, but I have 20 columns to do on a weekly basis so would like to
automate it in a macro.

The imported file is in the following format "04/04/2005 10:17:51"
dd/mm/yyyy hh:mm:ss

I recorded a Marco, but it does not work in cells with a date 13+ for
example 13/04/2005 10:17:51 remains in text format?

Can any one let me know what I'm doing wrong or suggest VB code to solve this.

My knowledge of VB is poor, so go easy on me!