Dear Sanjib, Please use below code as per your requirement.
*Function Date_Format(d As Date) Date_Format = Format(d, "dd-mmm-yyyy") End Function * On Fri, Sep 30, 2011 at 1:19 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > 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 > -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> -- ---------------------------------------------------------------------------------- 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