$$Excel-Macros$$ Query on dd-mm & mm-yy format

Hello Friends, Find attached excel file for ref. I'm using one software which list out required material for structure in excel. Output of that excel file converts some length of "Ft-In" format in "mm-dd-yy or mm-yy" format. Ex: For Length 10-11, excel shows Nov-11 & For length 11-10, excel shows

Fwd: $$Excel-Macros$$ Query on dd-mm & mm-yy format

which are in correct format. Please review. Thanks & regards, Suyog K -- Forwarded message -- From: Suyog Kulkarni Date: Tue, Nov 15, 2011 at 10:32 AM Subject: $$Excel-Macros$$ Query on dd-mm & mm-yy format To: excel-macros@googlegroups.com Hello Friends, Find attached

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

Dear Suyog, Please see attached sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Nov 15, 2011 at 10:32 AM, Suyog Kulkarni wrote: > Hello

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

Hello Noorain, Thanks for quick response but I've added two problems in same excel. Please review & advice. Suyog On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI wrote: > Dear Suyog, > > Please see attached sheet. > > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogs

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

=IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)&"-"&IF(DAY(G23)=1,0,DAY(G23)),G23) Regards, Sam Mathai Chacko On Tue, Nov 15, 2011 at 3:28 PM, Suyog Kulkarni wrote: > Hello Noorain, > > Thanks for quick response but I've added two problems in same excel. > Please review & advi

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

Thanks Sam, I think my problem is solved. Regards, Suyog On Wed, Nov 16, 2011 at 12:01 AM, Sam Mathai Chacko wrote: > > =IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)&"-"&IF(DAY(G23)=1,0,DAY(G23)),G23) > > Regards, > > Sam Mathai Chacko > > On Tue, Nov 15, 2011 at 3:28 PM, Su