PC Review


Reply
Thread Tools Rate Thread

Correcting date format

 
 
Steve Vanderkolff
Guest
Posts: n/a
 
      19th Jun 2008
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

 
Reply With Quote
 
 
 
 
Cimjet
Guest
Posts: n/a
 
      19th Jun 2008
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
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:31 PM.