I seem to be missing something... PROVIDED that your Windows Date format is dd/mm/yyyy when you enter a string in this format, Excel recognizes it as a date.
As such, you can: Right-click the cell(s) select Format Cells on the Number tab, select "Date". There SHOULD be a format at the bottom called 14-Mar-2001 if not, then select "Custom" (instead of "Date") and enter dd-mmm-yyyy now... IF Excel is not recognizing your string of characters as an actual "date", then this method will not work, and you must either convert it to a date, or use string manipulations. 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: Sanjib Chatterjee <chatterjee.kolk...@gmail.com> To: excel-macros <excel-macros@googlegroups.com> Sent: Fri, September 30, 2011 3:49:05 AM Subject: $$Excel-Macros$$ Fwd: date format help Dear All Please go through the mail and help me. Ragards, sanjib ---------- Forwarded message ---------- From: Sanjib Chatterjee <chatterjee.kolk...@gmail.com> Date: Fri, Sep 30, 2011 at 12:15 PM Subject: date format help To: excel-macros <excel-macros@googlegroups.com> Dear All members, please help me regarding date format in Excel. I want to put the value in excel as "dd/mm/yyyy", but like to get the value as "dd-mmm-yyyy" (i.e. 30/09/2011 should display 30-sep-2011, 01/12/2011 should display 01-dec-2011) Thank you in advance Regards, Sanjib -- ---------------------------------------------------------------------------------- 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
