Date formating probelm

Shortly: is there a way to convert date-time data in format MDY HH:MM to format Y M D HH MM SS?

So that years, months, days, hours, minutes and seconds would be in their own columns. (Seconds would be zeroes in this case but I want the column to be there.) Maybe the following example data demonstrates my need best.

I have MDY data as follows:



09/24/08 13:16
09/24/08 13:17
09/24/08 13:18


I would like the data above to be in format Y M D H MM SS:

2008 09 24 13 16 00
2008 09 24 13 17 00
2008 09 24 13 18 00

Hi,

Try a custom format yyyy mm dd hh mm ss

You're right - didn't see that bit