Correcting date format

's Computer Specifications

I have a column of dates that has been entered as day/month/year and I need
to switch it ot month/day/year. Any suggestions how to do this? Using Excel
2003
Thanks
Steve

's Computer Specifications

Go to >Format>Cells>Numbers>Custom and type mm/dd/yyyy
HTH
Cimjet
"Steve Vanderkolff" <Steve (E-Mail Removed)> wrote in
message news:0F600B40-0E43-4152-A85C-(E-Mail Removed)...
>I have a column of dates that has been entered as day/month/year and I
>need
> to switch it ot month/day/year. Any suggestions how to do this? Using
> Excel
> 2003
> Thanks
> Steve
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Correcting date format?	StargateFan	Microsoft Excel Discussion	1	7th Apr 2007 04:48 PM
correcting a negative date formula	woodlot4	Microsoft Excel Misc	6	6th Nov 2005 10:05 AM
How do I prevent Excel from auto-correcting the date format?	=?Utf-8?B?V2F0dHM=?=	Microsoft Excel Misc	2	15th Sep 2005 02:08 PM
2003 address book in Word - correcting format	=?Utf-8?B?cmtvc2t5?=	Microsoft Outlook Discussion	0	9th Jun 2005 06:22 PM
correcting album release date	stewc	Windows XP Music	1	22nd Oct 2003 11:11 PM