Re: $$Excel-Macros$$ Date to Month formula

2013-04-10 Thread Pravin Gunjal
3 at 4:43 PM, Pravin Gunjal wrote: > >> *Thanks everyone. >> * >> >> -- Forwarded message ------ >> From: अनिल नारायण गवली >> Date: Tue, Apr 9, 2013 at 4:42 PM >> Subject: Re: $$Excel-Macros$$ Date to Month formula >> To: "excel-macro

Re: $$Excel-Macros$$ Date to Month formula

2013-04-09 Thread Abhishek Jain
=TEXT(D3,"-") Drag down. On Tue, Apr 9, 2013 at 4:35 PM, Pravin Gunjal wrote: > Hi, I would like to convert the date in to the month & year format as > follows/attached file. > > *Now* *Result* *DATE* *MONTH-YEAR* 7-Apr-12 April-2012 17-Apr-12 > April-2012 25-Apr-12 April-2012 2