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
