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

2011-11-25 Thread kJo
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 bavalek...@gmail.com Sender:excel-macros@googlegroups.com Date: Thu,

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

2011-11-25 Thread kJo
Gr8.. On Nov 25, 10:51 am, NOORAIN ANSARI noorain.ans...@gmail.com 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, krishnanm2...@gmail.com wrote: All, Is there a formula which converts text to date?

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, krishnanm2...@gmail.com wrote: All, Is there a formula which converts text to date? PFA the sample file which I am trying to convert..