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

2010-03-10 Thread sachinp1...@googlemail.com
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

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

2010-03-08 Thread sachinp1...@googlemail.com
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/ format manually. Is there any shortcut formula to derive this ? Requested to send the same as early as possible, if any. Actual Data

$$Excel-Macros$$ Re: Excel Query

2010-02-13 Thread sachinp1...@googlemail.com
gt; Best Regards, > Ayush Jain > > On Feb 13, 4:49 pm, "sachinp1...@googlemail.com" > > > > wrote: > > Hello Group Members, Is there any separate formula to take selcted > > characters from one cell for Exp. from Cell which contains > > 031031263089W01

$$Excel-Macros$$ Excel Query

2010-02-13 Thread sachinp1...@googlemail.com
Hello Group Members, Is there any separate formula to take selcted characters from one cell for Exp. from Cell which contains 031031263089W01, I want only 031263089. I gone from Right & Left Function But it's Little bit lengthy procedure. Please suggest. -- --

$$Excel-Macros$$ Re: Urgent!!!!!!!!!!

2009-07-10 Thread sachinp1...@googlemail.com
Hi, I'm new one to this group. I'm facing problem in excel for Date Formating.When I'm selecting Entire column of Date, after selecting to Date option in Format, all dates are not coming in same format. Can anybody help me out in this ? Excel sheet is attached for your reference. Thanks in A