Change format to mm dd yyyy hh mm ss

's Computer Specifications

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.

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:00E15175-3961-4B40-B834-(E-Mail Removed)...
>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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How 2 change date format - dd/mm/yyyy instead of mm/dd/yyyy	Dan Moore	Microsoft Outlook Discussion	1	4th Mar 2008 10:28 AM
how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel	=?Utf-8?B?SmFjayBXaWxzb24=?=	Microsoft Excel New Users	4	18th Jul 2006 01:57 PM
change date format from dd/mm/yyyy to mm/yyyy	=?Utf-8?B?ZmxvdzIz?=	Microsoft Excel Misc	2	9th Nov 2005 03:33 PM
change the date format dd/mm/yyyy to m/d/yy	Claudia Fong	Microsoft C# .NET	4	28th Jun 2005 05:10 PM
Change Date Format from(YYYY-MM-DD) to (MM-DD-YYYY)	DustinS	Microsoft Access	4	31st Mar 2005 03:31 AM