Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-26 Thread Sam Mathai Chacko
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

RE: $$Excel-Macros$$ Convert text to date using formula...

2011-11-26 Thread Asa Rossoff
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

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-25 Thread kJo
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

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-25 Thread kJo
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.. >

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread krishnanm2006
@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

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread krishnanm2006
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

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread Sundarvelan N
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

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread NOORAIN ANSARI
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

$$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread krishnanm2006
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