Hi,
I think that mm will return 02, while m will return 2
Regards - Dave
From: anil.bha...@tatacommunications.com
To: excel-macros@googlegroups.com
Date: Thu, 3 Feb 2011 14:02:16 +0530
Subject: RE: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA
Hi Aamir,
Please see the
Shahzad
Sent: Wednesday, February 02, 2011 11:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA
Dear Ashish,
why use "" and why use 4 times. And please tell other "Format text"
Regards,
Aamir Shahzad
On Wed, Fe
ked for month only u
> mentioned day and year also. good initiative. i like it
>
> --
> *From:* Rohan Young
>
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, 3 February, 2011 10:30:08 AM
> *Subject:* Re: $$Excel-Macros$$ HOW TO CONVERT DAT
$$ 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
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 =(1
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 wrote:
>
> type this in cell f5
>
> =TEXT(E5,"")
>
> On Wed, Feb 2, 2011 at 1:09 PM, solomon raju wrote:
>
>> Hi All,
>>
>> How can we
Hi ,
find here with your attached Sheet.. i used Choose() Function to get desired
result.
Rajan
On Wed, Feb 2, 2011 at 1:09 PM, solomon raju wrote:
> Hi All,
>
> How can we extract month in text. Can someone define some formula for
> this.
>
> Attached my question in clear.
>
> Regards,
> Sol
Thank You Ashish.
On Wed, Feb 2, 2011 at 2:53 PM, ashish koul wrote:
>
> type this in cell f5
>
> =TEXT(E5,"")
>
> On Wed, Feb 2, 2011 at 1:09 PM, solomon raju wrote:
>
>> Hi All,
>>
>> How can we extract month in text. Can someone define some formula for
>> this.
>>
>> Attached my questio
In cell F5 try the following formula:
=CHOOSE(MONTH(E5),"January","February","March","April","May",
"June","July","August","September","October","November","December")
On Wed, Feb 2, 2011 at 2:39 AM, solomon raju wrote:
> Hi All,
>
> How can we extract month in text. Can someone define some
just
=TEXT(E5,"")
On Wed, Feb 2, 2011 at 2:39 PM, solomon raju wrote:
> Hi All,
>
> How can we extract month in text. Can someone define some formula for
> this.
>
> Attached my question in clear.
>
> Regards,
> Solomon
>
>
>
--
---
Sent: Wednesday, February 02, 2011 1:10 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA
Hi All,
How can we extract month in text. Can someone define some formula for this.
Attached my question in clear.
Regards,
Solomon
Please find the attached
Regards,
Manoj Kumar
On Wed, Feb 2, 2011 at 1:09 PM, solomon raju wrote:
> Hi All,
>
> How can we extract month in text. Can someone define some formula for
> this.
>
> Attached my question in clear.
>
> Regards,
> Solomon
>
> --
>
> -
type this in cell f5
=TEXT(E5,"")
On Wed, Feb 2, 2011 at 1:09 PM, solomon raju wrote:
> Hi All,
>
> How can we extract month in text. Can someone define some formula for
> this.
>
> Attached my question in clear.
>
> Regards,
> Solomon
>
> --
>
> --
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 tric
14 matches
Mail list logo
