I need a way for EXCEL to accept and convert a date/time in the following context:from yyyy MMM DD TTTT to mm/dd/yyyy TT:TT

Example: 2006 Mar 25 1650 to 03/25/2006 16:50

Thanks for the help.

GB