*right click on cell go to format go to custom format and then type as DD/MM/YYYY* *you will get it what you are expecting :)* ** On Fri, Jul 29, 2011 at 7:14 PM, Paul Schreiner <schreiner_p...@att.net>wrote:
> Does Excel recognize the dd-mm-yyyy as a valid DATE? > > That is: Can you change the format to "long date" format > and it automatically changes 29-07-2011 to "Friday, July 29, 2011" > > If so, then excel recognizes the string as a "date", > > Technically, there are two types of "dates"... > 1) A string of characters that YOU interpret as a date. > 2) A string of characters that EXCEL interprets as a date. > > If EXCEL thinks it is a date, you can DISPLAY it in any way you choose > (almost) > > You can change the way an Excel date is DISPLAYED by: > > Right-click the cell, select Format Cells > on the Date Category, the Type called "14-Mar-01" is the format you're > looking for. > Select it and Hit "ok". > > Or, you can select the Custom format, and use dd-mm-yy. > > If you CANNOT change it to a "long date", that means that Excel thinks of > this > as a text string, not a date... > > In THAT case, you have to listen to my "dissertation" on the nature of > Excel Dates. > and treat the value as any other text string and extract the values you > wish to use. > > To avoid that, give the above a try and let us know if it takes care of it. > > > > *Paul* > > ----------------------------------------- > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *----------------------------------------- > > > ------------------------------ > *From:* Ashish Khandelwal <4everash...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Fri, July 29, 2011 7:55:11 AM > *Subject:* $$Excel-Macros$$ Date format > > Hi, > > I have a date string in the format of dd-mm-yyyy. I want to change in the > dd-mm-yy. > > The Output should be like 29-07-11 > > > Please help. > > > > Thanks & Regards, > > Ashish Khandelwal. > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
