Good choice Ayush. I also thought it was very good. It's the Worksheet-Function equivalent of putting comments after an apostrophe in VBA. Regards - Dave.
> Date: Wed, 17 Jun 2009 07:48:06 -0700 > Subject: $$Excel-Macros$$ Best Excel Tip Award of Week # 24 goes to HARMEET > SINGH > From: jainayus...@gmail.com > To: excel-macros@googlegroups.com > CC: harmeet.hew...@gmail.com > > > Hello Everyone, > > I am happy to inform you that the award of best excel Tip of Week # 24 > goes to Harmeet Singh. The tip submitted by Harmeet is as follows : > > Subject : Hidden text in Formula > Tip : =2018+1056-4*120+N("My Salary + Bonus - 4 weekly loan > repayments") > BY using *N() *formula You can enter hidden text in your formula. > > > It was very different, useful and unique tip among all the tips by the > participants. I encourage you all to submit such great tips which will > help all members in big way and let you win the prize. > > CONGRATULATIONS HARMEET !!!!!!!!!! > You are now nominated for monthly award & your name is published on > home page of this group. > > CHEERS !!! > > The competition of week # 25 is already started & you can submit your > tip in the thread mentioned below > http://groups.google.com/group/excel-macros/browse_thread/thread/8f60d8d55837f5c9# > > Please participate and win wonderful prizes. > > KEEP POSTING !!!! > > Thanks and best regards, > Ayush Jain > > _________________________________________________________________ View photos of singles in your area Click Here http://dating.ninemsn.com.au/search/search.aspx?exec=go&tp=q&gc=2&tr=1&lage=18&uage=55&cl=14&sl=0&dist=50&po=1&do=2&trackingid=1046138&r2s=1&_t=773166090&_r=WLM_EndText --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---