Welcome to Lockergnome.com!
HomeHome FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Changing date format

  
   Home -> Office -> General Discussions RSS
Next:  General Discussions: Sort Individual Cell Contents Alphabetical  
Author Message
nicki




Joined: Nov 20, 2007
Posts: 1



(Msg. 1) Posted: Tue Nov 20, 2007 10:32 am
Post subject: Changing date format
Currently, I have a list of several dates inserted into a spreadsheet. They are recorded as:
10/11/2005 (mm-dd-yyyy)

The problem is, excel seems to think that 10/11/2005 is in (dd-mm-yyyy) format.

I need to switch this around so that excel understands I am referring to October 11, 2005 and not November 10, 2005. Is there a way I can do this without retyping all the dates?

Thanks
Back to top
Login to vote
Stevesold




Joined: Aug 01, 2007
Posts: 13



(Msg. 2) Posted: Thu Nov 22, 2007 9:40 am
Post subject: Re: Changing date format [Login to view extended thread Info.]
Im using office 2007, If I select format>date I get the option for the date format ie mm/dd/yy or dd/mm/yy
Back to top
Login to vote
enjinn




Joined: Jan 14, 2008
Posts: 12



(Msg. 3) Posted: Mon Jan 14, 2008 4:32 pm
Post subject: [Login to view extended thread Info.]
You can use the Date function.

the format for this function is date(year,month,day)

so in your example, to switch it around:

=date(YEAR(A1),DAY(A1),MONTH(a1))

then apply the right formating for the cell to be mm/dd/yy
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> General Discussions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Categories:
 General
 Microsoft Windows XP
 Microsoft Windows Vista
 Microsoft Windows (other)
  Microsoft Office
 Microsoft Office (other)
 Computer Security
 Linux
 Movies

[ Contact us | Terms of Service/Privacy Policy ]