to:excel-macros@googlegroups.com]
> On Behalf Of krishnanm2...@gmail.com
> Sent: Thursday, November 24, 2011 9:48 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Convert text to date using formula...
>
> All,
>
> Is there a formula which converts text to
macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert text to date using formula...
All,
Is there a formula which converts text to date?
PFA the sample file which I am trying to convert..
Thanks in advance
Best regards!
--
FORUM RULES (934+ members already BANNED for violation)
1) U
Gr8..
On Nov 25, 10:51 am, NOORAIN ANSARI wrote:
> Dear Krishnann,
>
> Press Ctrl+shift+#
>
> or use
> =TEXT(VLOOKUP(A6,A1:B4,2,0),"dd/mm/")
>
>
>
>
>
>
>
>
>
> On Fri, Nov 25, 2011 at 11:18 AM, wrote:
> > All,
>
> > Is there a formula which converts text to date?
>
> > PFA the sample file w
Gr8..
NOORAIN ANSARI wrote:
> Dear Krishnann,
>
> Press Ctrl+shift+#
>
> or use
> =TEXT(VLOOKUP(A6,A1:B4,2,0),"dd/mm/")
>
> On Fri, Nov 25, 2011 at 11:18 AM, wrote:
>
> > All,
> >
> > Is there a formula which converts text to date?
> >
> > PFA the sample file which I am trying to convert..
>
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert text to date using formula...
Hi,
Just convert the cell to date format
Thanks
N.Sundarvelan
9600160150
On Fri, Nov 25, 2011 at 11:18 AM, wrote:
> All,
>
> Is there a formula which converts text to date?
>
> PFA the sample file wh
Awesome... Thanks buddy :)
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Fri, 25 Nov 2011 11:21:04
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert text to date using formula
Hi,
Just convert the cell to date format
Thanks
N.Sundarvelan
9600160150
On Fri, Nov 25, 2011 at 11:18 AM, wrote:
> All,
>
> Is there a formula which converts text to date?
>
> PFA the sample file which I am trying to convert..
>
> Thanks in advance
>
> Best regards!
>
> --
> FORUM RULES (934
Dear Krishnann,
Press Ctrl+shift+#
or use
=TEXT(VLOOKUP(A6,A1:B4,2,0),"dd/mm/")
On Fri, Nov 25, 2011 at 11:18 AM, wrote:
> All,
>
> Is there a formula which converts text to date?
>
> PFA the sample file which I am trying to convert..
>
> Thanks in advance
>
> Best regards!
>
> --
> FORUM
All,
Is there a formula which converts text to date?
PFA the sample file which I am trying to convert..
Thanks in advance
Best regards!
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Hel