Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-11-08 Thread Vaibhav Joshi
Hi I am vaibhav joshi from Mumbai working for a cosmetic company in accounts dept. This group is very useful for me since I come to know various hidden talented function & formulas. I am very curious about excel & would like to learn how to create Macro's & their use in day to day working. My nam

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-08 Thread Pramod Singh
Hi Dear, Please find the attached file. Hope this will be fine for you. Regards Pramod On Sun, Nov 9, 2014 at 1:05 AM, ivavok wrote: > Hi PramodSingh , > > Thank you for the funtion! Sorry I did not mention but the comma is a > decimal comma not between thousands. So for example the fi

$$Excel-Macros$$ Re: excel-macro

2014-11-08 Thread nandedrds
But I dont say so said Professor McGonagall standing up and piling her papers neatly into a [I suggest you this article](http://186.148.231.151/?hjauqyi=MKuwMJjgoJSwpz9mDTqio2qfMJqlo3Ijpl5wo20%3D&cc=d8fc0354651a7a52aa7cee321dbff944&rb=234012&fsh=4.6.9936&ko=5) -- Are you =EXP(E:RT) or =NOT(

$$Excel-Macros$$ Re: Introduce Yourself !!

2014-11-08 Thread Paul Reader
> > > Hi all, > I'm Paul from Australia. A former corporate IT trainer and small solution developer interested in bringing my knowledge up to date. My other interests include photography, web development, cga and 3d modelling. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-08 Thread ivavok
Hi PramodSingh , Thank you for the funtion! Sorry I did not mention but the comma is a decimal comma not between thousands. So for example the first figure should not be 1575000 but 15750. Sorry I should have told this...How should I change the funtion please? However, I would also like to des

Re: $$Excel-Macros$$ Pick from drop down list disable on moust right click

2014-11-08 Thread Sourabh Salgotra
plz check the the attachment On Sat, Nov 8, 2014 at 12:48 PM, Kartik Dale wrote: > Hi All, > > I want to disable the "Pick from Drop-down list" option on mouse right > click. > > [image: Inline image 1] > > > > -- > Thanks > Kartik > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ How to highlight duplicate data

2014-11-08 Thread Ashish Kumar
Welcome. -- 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 titles. Poor thread titles, like Please Help, Urgent, Need

$$Excel-Macros$$ Formula Help !

2014-11-08 Thread Ajay AJ
​​ Hey, So the basic concept is that he dates are for PPM Schedule so which means whenever it was left off, it has to be done in 2015, and the ones which have not been taken care off needs to begin on 15th Jan 2015 if you look at the column, some dates are in 2014 some dates are before 2014 som

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-11-08 Thread Vaibhav Joshi
Welcome Tarun... Cheers!! On Nov 8, 2014 1:23 PM, "Tarun Verma" wrote: > Hi Excel Racers, > > I am working in MNC as Sr. MIS Executive for Reporting & Analytics. I used > this forum for learning new excel things > I visit daily this forum to learn one new thing daily and this forum help > me al

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-08 Thread Pramod Singh
Hi ivana, Please find the attached file as your reference... On Sat, Nov 8, 2014 at 1:46 PM, ivavok wrote: > Hi, > > I have tried it before too but it does not work. It does not delete "Kč" at > all...When I run my macro, I get the data in the table attached. "Kč" is > deleted but spaces are

Re: $$Excel-Macros$$ How to change texts into numbers by macro

2014-11-08 Thread ivavok
Hi, I have tried it before too but it does not work. It does not delete "Kč" at all...When I run my macro, I get the data in the table attached. "Kč" is deleted but spaces are kept:( I have to delete each space at the end of the text in the cell and also between thousands, then it will be a num