Re: $$Excel-Macros$$ SOLVE THIS

Both is working good .. On Fri, Feb 27, 2015 at 11:55 AM, Mayank Mishra wrote: > Try > =DATE("20"&RIGHT(A1,2),MID(A1,4,2),MID(A1,2,2)) > > It will convert the string as date > > On 2/27/15, Sam Mathai Chacko wrote: > > =--TEXT(RIGHT(A1,6),"00\/00\/00") > > On 27 Feb 2015 11:47, wrote: > > > >>

Re: $$Excel-Macros$$ SOLVE THIS

Try =DATE("20"&RIGHT(A1,2),MID(A1,4,2),MID(A1,2,2)) It will convert the string as date On 2/27/15, Sam Mathai Chacko wrote: > =--TEXT(RIGHT(A1,6),"00\/00\/00") > On 27 Feb 2015 11:47, wrote: > >> I have a data like below where I need only date. >> >> S270215 >> R270215 >> >> -- >> Are you =EXP(

Re: $$Excel-Macros$$ SOLVE THIS

=--TEXT(RIGHT(A1,6),"00\/00\/00") On 27 Feb 2015 11:47, wrote: > I have a data like below where I need only date. > > S270215 > R270215 > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://

$$Excel-Macros$$ SOLVE THIS

I have a data like below where I need only date. S270215 R270215 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread