=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 <suyog.kulka...@yahoo.com>wrote: > 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 > <noorain.ans...@gmail.com>wrote: > >> Dear Suyog, >> >> Please see attached sheet. >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >> >> On Tue, Nov 15, 2011 at 10:32 AM, Suyog Kulkarni < >> suyog.kulka...@yahoo.com> wrote: >> >>> 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 >>> 10/11/11. >>> >>> Somehow I need to keep all length either in text format or in Ft-inch >>> format. I'm not importing file into excel so I can't fix the "text type" >>> for particular column. >>> >>> Manual edition will be tedious as there are more than 75 pages (Each >>> have more than 1000 rows), If anybody can suggest any easy way to save time. >>> >>> Thanks & regards, >>> -- >>> *Suyog Kulkarni* >>> Mailto:-suyog.kulka...@yahoo.com >>> suyog.kulka...@hotmail.com >>> Ph:-( +91 ) 9890123539 >>> >>> -- >>> FORUM RULES (934+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> >> >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > -- > Suyog Kulkarni > Mailto:-suyog.kulka...@yahoo.com > suyog.kulka...@hotmail.com > Ph:-( +91 ) 9890123539 > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- Sam Mathai Chacko -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
3042(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
