Congrats Mr.Manoj..
-- Forwarded message --
From: ayush jain
Date: Sat, Jan 8, 2011 at 2:49 PM
Subject: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar
To: excel-macros@googlegroups.com
Cc: manoj.vishwakarma...@gmail.com
Dear Group,
The winner of this puzzle h
Thanks Ashish , Manoj & Maries...Your solutions are great !!
Maries, We can ignore Value formula from your solution and it still work ...
like =TEXT(A11&1,"m")
Till now, Manoj's formula is smallest and easiest ...
Any one else wanna solve or comment on puzzle?
Regards,
Ayush Jain,
Microsoft
Dear Ayush Jain,
Please find the attached file. this also one of way to find the months using
the following formula.
=TEXT(VALUE(A1&1),"m")
Thank you,
Regards,
Maries
-- Forwarded message --
From: Rohan Young
Date: Thu, Jan 6, 2011 at 2:08 PM
Subject: Re: $$Excel-Macros$$ Exc
Dear Ayush Jain,
Please find the attached file. this also one of way to find the months using
the following formula.
=TEXT(VALUE(A1&1),"m")
Thank you,
Regards,
Maries
-- Forwarded message --
From: Rohan Young
Date: Thu, Jan 6, 2011 at 2:08 PM
Subject: Re: $$Excel-Macros$$ Excel
