Format Custom and type or paste your format string (mm dd yyyy hh mm ss,) in
the Type box

--
Kind regards,

Niek Otten
Microsoft MVP - Excel
"Thomas" wrote in message
...
I am currently trying to convert my cells from this format 11/9/2009
08:26:21:523 to just mm dd yyyy hh mm ss, format. if anyone knows how to
do
this, Your Help would be greatly appreciated.