Trasformare data formato testo

[galassya]

ricevo il testo il questo formato:
5/17/07 2:00 PM Local Time

vorrei trasformarlo cosi:
17 mag 2007 14:00 Local Time

come riesco a fare tutto cio??

[Teo80]

Prova

FormatDateTime(Date[, NamedFormat])

Settings
The NamedFormat argument has the following settings:

vbGeneralDate 0: Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed.
vbLongDate 1: Display a date using the long date format specified in your computer's regional settings.
vbShortDate 2: Display a date using the short date format specified in your computer's regional settings.
vbLongTime 3: Display a time using the time format specified in your computer's regional settings.
vbShortTime 4: Display a time using the 24-hour format (hh:mm).

Chiaramente prima devi convertire il testo in data con CDate.