Hi,

use this formula in VBA:

date=cdate(mid("Wed 17 Nov 2004 05:34P ",4,len("Wed 17 Nov 2004
05:34P ")-4))

You will get date as result.

In case you want to convert it somehow else, explore type conversion
functions in VBA help.

Regards,
Ivan