Dear Users,
It can be possible with =SUBSTITUTE(SUBSTITUTE(B2,".","/",1),".","/") also
an another approach.
Warm Regards,
Gawli Anil.
On Tue, Feb 19, 2013 at 6:23 PM, Kuldeep Singh wrote:
>
> Hi Harshad,
>
> Try this one.
>
> *=MID(SUBSTITUTE(SUBSTITUTE(A2,".","/",2),".","/",1),1,10)*
>
> Reg
the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Maries
To: excel-macros@googlegroups.com
Sent: Tue, February 19, 2013 11:18:14 AM
Subject: Re: $$Excel-Macros$$ Please share inputs to format Date
HI,
Try it,
=TEXT(SUBSTITUTE(A1,".&q
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
____
From: Kuldeep Singh
To: excel-macros@googlegroups.com
Sent: Tue, February
Hi Harshad,
Try this one.
*=MID(SUBSTITUTE(SUBSTITUTE(A2,".","/",2),".","/",1),1,10)*
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print thi
are you wanting a VBA solution or an Excel solution?
For Excel:
If your string is consistent, as the formatting suggests,
and the date is in cell A1, then you can use:
=DATEVALUE(MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A1,4))
Paul
-
“Do all the good you ca
