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*
>
>
> --
>
> ---
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
=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
=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