Re: $$Excel-Macros$$ How can convert ""

2011-10-24 Thread NOORAIN ANSARI
Dear Rajiv, Please see attached sheet. On Sun, Oct 23, 2011 at 7:17 PM, R@jiv Kum@r wrote: > > > -- > *Thanks & Regards > > * > *Rajiv Kumar > * > *Mawana Sugar Works, Mawana > * > *Mo.No: 09027414899* > > > -- > > ---

RE: $$Excel-Macros$$ How can convert ""

2011-10-23 Thread Siraj Momin (BTG)
PFA Best Regards Momin Siraj Ahmad From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of R@jiv Kum@r Sent: 23 October 2011 05:47 PM To: excel-macros Subject: $$Excel-Macros$$ How can convert "" -- Thanks & Regards Rajiv Kumar Mawana Sugar

Re: $$Excel-Macros$$ How can convert ""

2011-10-23 Thread dguillett1
=DATEVALUE(MID(H9,3,2)&"/"&LEFT(H9,2)&"/"&RIGHT(H9,4)) and then format your cells as desired such as dd/mm/ Don Guillett SalesAid Software dguille...@gmail.com From: mailto:xlraja...@gmail.com Sent: Sunday, October 23, 2011 8:47 AM To: excel-macros Subject: $$Excel-Macros$$ How can

Re: $$Excel-Macros$$ How can convert ""

2011-10-23 Thread ashish koul
=SUBSTITUTE(TEXT(C9,"@"),"/","") On Sun, Oct 23, 2011 at 7:17 PM, R@jiv Kum@r wrote: > > > -- > *Thanks & Regards > > * > *Rajiv Kumar > * > *Mawana Sugar Works, Mawana > * > *Mo.No: 09027414899* > > > -- > > -- > S