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 xlraja...@gmail.com wrote: -- *Thanks Regards * *Rajiv Kumar * *Mawana Sugar Works, Mawana * *Mo.No: 09027414899* --

$$Excel-Macros$$ How can convert

2011-10-23 Thread R@jiv Kum@r
-- *Thanks Regards * *Rajiv Kumar * *Mawana Sugar Works, Mawana * *Mo.No: 09027414899* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

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 xlraja...@gmail.com wrote: -- *Thanks Regards * *Rajiv Kumar * *Mawana Sugar Works, Mawana * *Mo.No: 09027414899* -- -- Some

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 convert

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