Re: $$Excel-Macros$$ DD/MM/YYYY Excel Query

I atatched a spreadsheet. Try that. On Mon, Mar 8, 2010 at 4:52 AM, sachinp1...@googlemail.com < sachinp1...@googlemail.com> wrote: > Hello Members, I want help regarding this in which we receive the data > in below mentioned date period format.where we have to convert in > actual dd/mm/ f

Re: $$Excel-Macros$$ DD/MM/YYYY Excel Query

Hi Sachin, Hope this formula works for you! If the Actual data is in ColA & Row 1 then the formula in red shud be entered in ColB&Row1.. =RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4) Thanks Surya On Mon, Mar 8, 2010 at 4:22 PM, sachinp1...@googlemail.com < sachinp1...@googlemail.com> wrote: >

Re: $$Excel-Macros$$ DD/MM/YYYY Excel Query

Thanks ! Regards Sachin On Mar 8, 6:38 pm, rf1234 rf1234 wrote: > Hello Dear > date format 01/10/2009-31/10/2009 i.e > date/month/year-date/month/year > > is not feasible. > > Hope It will Help > Happy To Help > :) > Shyam > > On Mon, Mar 8, 2010 at 4:22 PM, sachinp1...@googlemail.com < > > > >

Re: $$Excel-Macros$$ DD/MM/YYYY Excel Query

Hello Dear date format 01/10/2009-31/10/2009 i.e date/month/year-date/month/year is not feasible. Hope It will Help Happy To Help :) Shyam On Mon, Mar 8, 2010 at 4:22 PM, sachinp1...@googlemail.com < sachinp1...@googlemail.com> wrote: > Hello Members, I want help regarding this in which we re