Re: $$Excel-Macros$$ Excel learning Institute

What address or contact number pls? Any where in Borivli ? On Nov 24, 2:07 pm, krishnanm2...@gmail.com wrote: > Andheri east > > Sent on my BlackBerry® from Vodafone > > > > > > > > -Original Message- > From: mangesh bavalekar > > Sender:excel-macros@googlegroups.com > Date: Thu, 24 Nov

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

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...

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.. >