Change format to mm dd yyyy hh mm ss

T

Thomas

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.
 
N

Niek Otten

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