Re: $$Excel-Macros$$ Fwd: date format help

2011-09-30 Thread Sourabh Salgotra
SIMPLE WAY SELECT THAT CELLS GO TO FORMAT CELLS THEN CLICK ON NUMBER--CUSTOM--- TYPE THE DD-MMM-YY IN THE TYPE FIELD On Fri, Sep 30, 2011 at 2:28 PM, Amresh Maurya wrote: > Hi PFA Solution. > > On Fri, Sep 30, 2011 at 12:49 AM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com>

Re: $$Excel-Macros$$ Fwd: date format help

2011-09-30 Thread Subhash Yadav
You can select the date format as dd-mmm- format cell option. On 30 Sep 2011 13:19, "Sanjib Chatterjee" wrote: > Dear All > > Please go through the mail and help me. > > Ragards, > > sanjib > > -- Forwarded message -- > From: Sanjib Chatterjee > Date: Fri, Sep 30, 2011 at 12:1

Re: $$Excel-Macros$$ Fwd: date format help

2011-09-30 Thread Paul Schreiner
As long as ever you can.” - John Wesley - From: Sanjib Chatterjee To: excel-macros 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 Chat

Re: $$Excel-Macros$$ Fwd: date format help

2011-09-30 Thread NOORAIN ANSARI
Dear Sanjib, Please use below code as per your requirement. *Function Date_Format(d As Date) Date_Format = Format(d, "dd-mmm-") 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. >

Re: $$Excel-Macros$$ Fwd: date format help

2011-09-30 Thread anil kumar
Hello Dear, I think It's work use this key Shift+Ctrl+3. -- -- 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 @

$$Excel-Macros$$ Fwd: date format help

2011-09-30 Thread Sanjib Chatterjee
Dear All Please go through the mail and help me. Ragards, sanjib -- Forwarded message -- From: Sanjib Chatterjee Date: Fri, Sep 30, 2011 at 12:15 PM Subject: date format help To: excel-macros Dear All members, please help me regarding date format in Excel. I want to put th