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