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,"dddd") = result =(Saturdary)
for Month : Text(a1,"mmm") = result =(Jan)
Text(a1,"mmmm") = result =(January)
for Year : Text(a1,"yy") = result =(11)
Text(a1,"yyy") = result =(2011)
Text(a1,"yyyy") = result =(2011)
regards
ROHAN
9818247278
On Wed, Feb 2, 2011 at 11:23 PM, Aamir Shahzad <aamirshahza...@gmail.com> wrote:
Dear Ashish,
>
>
>
>why use "mmmm" 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.com> wrote:
>
>
>>type this in cell f5
>>
>>=TEXT(E5,"mmmm")
>>
>>
>>On Wed, Feb 2, 2011 at 1:09 PM, solomon raju <faithful1...@gmail.com> wrote:
>>
>>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
>>>
>>><><><><><><><><><><><><><><><><><><><><><><>
>>>Like our page on facebook , Just follow below link
>>>http://www.facebook.com/discussexcel
>>>
>>
>>
>>--
>>
>>Regards
>>
>>Ashish Koul
>>akoul.blogspot.com
>>akoul.wordpress.com
>>My Linkedin Profile
>>
>>PBefore 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
>>
>
>
--
>----------------------------------------------------------------------------------
>
>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
--
----------------------------------------------------------------------------------
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
