Re: $$Excel-Macros$$ RE: help required urgently

2014-03-27 Thread Vabs
Hi You can format cell as DD-Mmm- or you can use formula =text(ref,"DD-Mmm-) where ref is your reference cell. Thanks On Thu, Mar 27, 2014 at 4:52 PM, Neeraj Chauhan wrote: > Dear experts, > > > > We have given below date format how to convert right format of date like > 13-Jan-2014

$$Excel-Macros$$ RE: help required urgently

2014-03-27 Thread Neeraj Chauhan
Dear experts, We have given below date format how to convert right format of date like 13-Jan-2014 TT Modified Date & Time 13/01/2014 15/01/2014 19:51 2-Nov-14 1-Jun-14 2-Nov-14 15/01/2014 19:57 1-Jun-14 13/01/2014 17:10 15/01/2014 19:47 18/01/2014 15:44 From:

$$Excel-Macros$$ Re: Help Required - Urgently

2009-06-04 Thread Nishant Jain
i have sent you an attachement on your email id as i am unable to attached the file here... Nishant On Jun 4, 8:02 am, Ankit Mehra wrote: > Hi Paul, > > Let me answer your questions one by one.. > > 1. All the data for validation, either for col A or for col B is kept in a > sheet. This sheet i

$$Excel-Macros$$ Re: Help Required - Urgently

2009-06-03 Thread Paul Schreiner
We have to be careful in "assuming" that the terminology you are using means the same for us as it does for you. To ME, what you said is that you want to select one of the cells in Column A and have a list of data in column B to change. there are many, many questions that arise. Where do you get