Change format to mm dd yyyy hh mm ss
 

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.

Change format to mm dd yyyy hh mm ss
 

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.