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

2011-11-16 Thread Nikhil Shah
to calculate age of vehicle... > > ** ** > > Regards, > > *Amit Desai* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* 16 November 2011 13:00 > *To:* excel-macros@goo

RE: $$Excel-Macros$$ date format changes

2011-11-16 Thread Amit Desai (MERU)
@googlegroups.com Subject: Re: $$Excel-Macros$$ date format changes Dear Amit, Please try this formula. =TEXT(A5,"dd-mmm-yy") in vba, You can use Function Date_format(rng As Range) Date_format = VBA.Format(rng, "dd-mmm-yy") End Function -- Thanks & rega

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

2011-11-15 Thread NOORAIN ANSARI
Dear Amit, Please try this formula. =TEXT(A5,"dd-mmm-yy") in vba, You can use Function Date_format(rng As Range) Date_format = VBA.Format(rng, "dd-mmm-yy") End Function -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://n

$$Excel-Macros$$ date format changes

2011-11-15 Thread Amit Desai (MERU)
Dear All, How can i change 01/25/2011 to 25-Jan-2011 with a formula.. i have tried changing it with text to column (date option)... also done format cell option..but could not work... Regards, Amit Desai Disclaimer: This message and its attachments contain conf