Hmm...I don't see a decimal point in the OP's "14/04/03 14:20".

What version of XL are you using. My solution works fine in XL03 and
XL04.

If the date is not in your date format (i.e., if it's dmy and you use
mdy), to to the third pane of the Text to Columnyou can select first
column in the third pane and choose the dmy option from the Date
dropdown. That will coerce what the parser would see as a text value to
a date.


In article ,
"Biff" wrote:

That's not working for me. Not working means nothing
happens.

What does work is T to C.
Fixed width
Place the delimiter before the decimal point.

Still have to manually format as desired.

Couldn't come up with a formula solution that's really
much better than what the OP is already doing.