$$Excel-Macros$$ Please shorten the signature message

2012-09-23 Thread V S Rawat g
The following is the long singature message of this group. why not shorten it? programmers are known for brevity. No point really posting long 7 rules with each mail reaching so many members. These rules can be sent once at the time of joining/ subscription to the group. Thanks. -- Rawat

Re: $$Excel-Macros$$ WEEKDAY function of excel - need character day

2012-09-23 Thread Swapnil Palande
And if you don't want to use formula then use custom format of cell as "ddd" On Sep 24, 2012 11:55 AM, "Swapnil Palande" wrote: > Hi, > > Use TEXT function. > > Ex: =text(A2, "ddd") > On Sep 24, 2012 11:46 AM, "V S Rawat g" wrote: > >> Is there a function in excel 2013 that would give character

Re: $$Excel-Macros$$ WEEKDAY function of excel - need character day

2012-09-23 Thread Swapnil Palande
Hi, Use TEXT function. Ex: =text(A2, "ddd") On Sep 24, 2012 11:46 AM, "V S Rawat g" wrote: > Is there a function in excel 2013 that would give character day of week > (e.g Mon, Tue...). > > Weekday function is giving numeric day, what is the fun of it. do we need > to write another function or

$$Excel-Macros$$ Re: WEEKDAY function of excel - need character day

2012-09-23 Thread Vabz
hi use following formula.. =TEXT(A1, "") Where cell A1 contains date. Rgds//Vabs On Monday, September 24, 2012 11:46:07 AM UTC+5:30, Rawat wrote: > > Is there a function in excel 2013 that would give character day of > week (e.g Mon, Tue...). > > Weekday function is giving numeric day, w

Re: $$Excel-Macros$$ WEEKDAY function of excel - need character day

2012-09-23 Thread NOORAIN ANSARI
Dear VS, You can use it for weekday as Character day of week. =CHOOSE(WEEKDAY(A2),"Sun","Mon","Tue","Wed","Thu","Fri","Sat") or =LOOKUP(WEEKDAY(A2),{1,2,3,4,5,6,7},{"Sun","Mon","Tue","Wed","Thu","Fri","Sat"}) see attached sheet for more clarity. On Mon, Sep 24, 2012 at 11:45 AM, V S Rawat g

$$Excel-Macros$$ WEEKDAY function of excel - need character day

2012-09-23 Thread V S Rawat g
Is there a function in excel 2013 that would give character day of week (e.g Mon, Tue...). Weekday function is giving numeric day, what is the fun of it. do we need to write another function or macro just to convert this numeric day to sun, mon... Thanks. -- Rawat -- Join official facebook

excel-macros@googlegroups.com

2012-09-23 Thread sunil jagtap
Hi Noorain, Thank you so much. Thanks and Regards, Sunil On Mon, Sep 24, 2012 at 11:16 AM, NOORAIN ANSARI wrote: > Dear Sunil, > > See attachment, Hope it will help to you. > > > On Mon, Sep 24, 2012 at 11:13 AM, sunil jagtap wrote: > >> Hi Groups, >> >> Please share the interview Q&A for advan

excel-macros@googlegroups.com

2012-09-23 Thread sunil jagtap
Hi Groups, Please share the interview Q&A for advance excel and VBA macros. Thanks in advance. -- Thanks and Regards Sunil Jagtap Email id : jagtapsun...@gmail.com Cell no :91+ 8880623095 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+

$$Excel-Macros$$ Re: SLIM AND EYE CATCHING BODY

2012-09-23 Thread Prince Dubey
Hi Ayush, Please bane this user. regards Prince On Sunday, September 23, 2012 1:36:45 PM UTC+5:30, Louis Ranjhan wrote: > > SLIM AND EYE CATCHING BODY > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violat

Re: $$Excel-Macros$$ SLIM AND EYE CATCHING BODY

2012-09-23 Thread NOORAIN ANSARI
Hi Louis, This is excel-macro group, please send Excel related query or solution. Don't send this type of mail. On Sun, Sep 23, 2012 at 1:36 PM, Louis Ranjhan wrote: > SLIM AND EYE CATCHING BODY > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > >

$$Excel-Macros$$ Re: need guidance in learning macros and VBA

2012-09-23 Thread Prince Dubey
Hi Ram Gopal, Please see these links these will help you to learn. http://home.pacbell.net/beban http://excel.tips.net http://www.andrewsexceltips.net/ http://www.andypope.info/ http://akoul.blogspot.com http://www.ashishmathur.com http://www.discussexcel.com http://members.aol.

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-23 Thread Indrajit $nai
*@ Group, *suppose I've 200 files in a particular path, now I want to consolidate all of those files data in the master file, I mean to say; in a master file there is a button which will consolidate all the data from those 200 slave file through a single click. Hope it's possible through VBA, if it

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-23 Thread Indrajit $nai
Thanks *Krishna*, thanks a lot. :) it's a gr8 solution. :) -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you

$$Excel-Macros$$ SLIM AND EYE CATCHING BODY

2012-09-23 Thread Louis Ranjhan
SLIM AND EYE CATCHING BODY -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Pro

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-23 Thread Indrajit $nai
*@Group, @ Rajan, @ Don - any solution?* Thanks & Regards, Indrajit On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai wrote: > *@ Rajan, *Yes there are 200 files with the same format. I can do the > consolidation part through VBA, it's not a problem. > > It will be like; there should be a button