Re: $$Excel-Macros$$ Date format to be changed

Date: Sat, Jun 22, 2013 at 5:51 PM > Subject: Re: $$Excel-Macros$$ Date format to be changed > To: excel-macros@googlegroups.com > > > Dear Pravin : > > Use the below > =TEXT(DATE(RIGHT(B4,4),MID(B4,4,2),LEFT(B4,2)),"DD-MMM-")​ > > > On Sat, Jun 22, 2013 at 3:

Re: $$Excel-Macros$$ Date format to be changed

ere after long time.. > > Regards > Pravin Gunjal. > > -- Forwarded message -- > From: Ahmed Honest > Date: Sat, Jun 22, 2013 at 5:51 PM > Subject: Re: $$Excel-Macros$$ Date format to be changed > To: excel-macros@googlegroups.com > > > Dear Pravi

Re: $$Excel-Macros$$ Date format to be changed

orwarded message -- > From: VBA VABZ > Date: Sat, Jun 22, 2013 at 3:38 PM > Subject: Re: $$Excel-Macros$$ Date format to be changed > To: "excel-macros@googlegroups.com" > > > Select cell, right click, format cell, custom & type DD--. > > You c

Re: $$Excel-Macros$$ Date format to be changed

Select cell, right click, format cell, custom & type DD--. You can use text(cell,"DD-MMM-") also. Thanks On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal wrote: > I have date in this format : *DD.MM.* (with dot) and require it as : * > DD-MMM-* (with hyphen). > For example :