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
>
>
>
--
---
Simple way is create separate table where you will get months than do
VLOOKUP... :)
Like 1 = April, 2 = May, 3 = Juneetc.
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of solomon raju
Se
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
>
> --
>
> --
13 matches
Mail list logo
