Change format to mm dd yyyy hh mm ss

  • Thread starter Thread starter Thomas
  • Start date Start date
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.
 
Format Custom and type or paste your format string (mm dd yyyy hh mm ss,) in
the Type box
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting MM/DD/YYYY into just MM/DD and Sorting 1
format cells from mm/dd/yyyy to yyyy 3
dd/mm/yyyy 3
Forcing a date entry format of dd/mm/yyyy 1
How to enter a date in DD-MM-YYYY format 2
Converting date format 4
How to convert mm/dd/yyyy date format to yyyy-mm-dd 3
Day of Week from dd/mm/yyyy 7

Back
Top