Re: $$Excel-Macros$$ date format in Excel

2011-10-01 Thread Ms-Exl-Learner .
Hi Sanjib, If it is real date then sir dguillett suggestion will work fine... --- Ms.Exl.Learner --- On Fri, Sep 30, 2011 at 11:03 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear > > I like to put the date format in Excel as "dd/mm/yyy

Re: $$Excel-Macros$$ date format in Excel

2011-09-30 Thread XLS S
Select cell or column then right click format cell ...then in number tab go to date and select date format then ok On Fri, Sep 30, 2011 at 11:03 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear > > I like to put the date format in Excel as "dd/mm/",

Re: $$Excel-Macros$$ date format in Excel

2011-09-30 Thread dguillett1
If ??? I understand, simply CUSTOM format the cell as "dd-mm- From: Sanjib Chatterjee Sent: Friday, September 30, 2011 12:33 AM To: excel-macros Subject: $$Excel-Macros$$ date format in Excel Dear I like to put the date format in Excel as "dd/mm/", and like to get the output as "dd-mm

Re: $$Excel-Macros$$ date format in Excel

2011-09-29 Thread NOORAIN ANSARI
Dear Sanib Da, Please use below formula and see attached sheet. * =TEXT(MID(A2,FIND("/",A2,1)+1,2)&"-"&LEFT(A2,FIND("/",A2,1)-1)&"-"&RIGHT(A2,LEN(A2)-FIND("/",A2,FIND("/",A2,1)+1)),"dd-mmm-") * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*