date:20110203

Re: $$Excel-Macros$$ Ashish Koul : Most helpful member : Jan11

2011-02-03 Thread ashish koul

Thank you all...

On Thu, Feb 3, 2011 at 12:36 PM, Umesh Dev umesh.d...@gmail.com wrote:

 congrats Ashish


 Regards
 Umesh Dev

  On Wed, Feb 2, 2011 at 8:25 PM, Ayush jainayus...@gmail.com wrote:

  Ashish Koul has been selected as *'Most Helpful Member'* for the month
 of Jan 2011.
 He has posted over 75 posts (11% of total posts) in January 2011 and
 helped many people through his expertise. He has been consistent contributor
 to this excel forum.

 *Many Many Thanks Ashish for wonderful support to group.*

 *About Ashish Koul*
 Ashish resides in Delhi, India and currently working  with CSC. He is
 automation expert and his role is to automate tasks using VBA Macros and
 Advanced Excel. His favorite pass time is solving Excel Queries, Listening
 Music  Traveling.


  Best Regards,

 Ayush Jain

 Group Manager.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA

2011-02-03 Thread ashish koul

check out this link
http://www.techonthenet.com/excel/formulas/text.php
http://office.microsoft.com/en-us/excel-help/text-HP005209313.aspx?CTT=5origin=HP005203209

On Thu, Feb 3, 2011 at 12:20 PM, hanumant shinde
hanumant_5...@yahoo.co.inwrote:

hi Rohan,

that was cool. good info even though it was asked for month only u
mentioned day and year also. good initiative. i like it

--
*From:* Rohan Young rohan.j...@gmail.com

*To:* excel-macros@googlegroups.com
*Sent:* Thu, 3 February, 2011 10:30:08 AM
*Subject:* Re: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA

hi,

for converting the date formate, if a1 has the date 01/01/2011 :

for Day : Text(a1,ddd) = result =(Sat)
Text(a1,) = result =(Saturdary)

for Month : Text(a1,mmm) = result =(Jan)
Text(a1,) = result =(January)

for Year : Text(a1,yy) = result =(11)
Text(a1,yyy) = result =(2011)
Text(a1,) = result =(2011)

regards

ROHAN
9818247278
On Wed, Feb 2, 2011 at 11:23 PM, Aamir Shahzad
aamirshahza...@gmail.comwrote:

Dear Ashish,

why use and why use 4 times. And please tell other Format text

Regards,

Aamir Shahzad

On Wed, Feb 2, 2011 at 3:53 PM, ashish koul koul.ash...@gmail.comwrote:

type this in cell f5

=TEXT(E5,)

On Wed, Feb 2, 2011 at 1:09 PM, solomon raju faithful1...@gmail.comwrote:

Hi All,

How can we extract month in text. Can someone define some formula for
this.

Attached my question in clear.

Regards,
Solomon
--

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com