Re: $$Excel-Macros$$ re: conversion of numbers

2011-11-29 Thread harsh shah
t;>> Custom.. The result will be 100 >>>> Option 2 = If base data is 10 - type *#,,* in Format Cells --> >>>> Custom.. The result will be 1000 >>>> Option 3 = If base data is 10 - type *#,#,* in Format Cells >>>> --> C

$$Excel-Macros$$ re: conversion of numbers

2011-11-26 Thread harsh shah
dear all, i have a data sheet with numbers in it. i want to convert them into thousands or in lacs. is there a way to format the selected data cells so as to convert the same in thousands or in lacs ? harsh. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ remove a certain text from every sentence

2011-11-09 Thread harsh shah
you can use find & replace. On 10 November 2011 10:39, smitha.kumari wrote: > Hi, > > ** ** > > I want to remove a certain text from every sentence > > Technology Company:David > > Technology Company:Arya > > Technology Company:Jose > > ** ** > > I need only the name, “Techno

Re: $$Excel-Macros$$ Lesson 1: The Visual Basic Editor in Excel (VBE)

2011-07-25 Thread harsh shah
awaiting more lessons On 26 July 2011 09:24, XLS S wrote: > ** > > *Lesson 1: The Visual Basic Editor in Excel (VBE) > * > > *For users of Excel 1997 to 2006:* The first thing that you need to do is > to make sure that the security level of Excel is set at either "Low" or > "Medium" so that

Re: $$Excel-Macros$$ Help regarding bank statment

2011-07-07 Thread harsh shah
HOPE THIS MIGHT BE USEFUL. On 8 July 2011 10:09, L.K. Modi wrote: > Dear Members, > > Thanks for your valuable support. I have an querry in which i have to check > interest calculation for banks. > > Me attaching a sheet in which column A have date that is in different > format. and in column B

Re: $$Excel-Macros$$ Excel Password Breaker Code...

2011-03-26 Thread harsh shah
let me know how to use the same to break existing password protected sheet. On 24 March 2011 15:35, NOORAIN ANSARI wrote: > Dear Experts., > > Please find & use below VBA code to break password in EXCEL > > Procedure : Press alt+F11 > Insert-Module then Paste below code >

Re: $$Excel-Macros$$ Freeze the cell once the Data has been entered?

2009-12-13 Thread harsh shah
hey this was good one 2009/12/13 Dilip Pandey > Dear Ramesh, > > Required automation is attached herewith. > > Thanks & Best Regards, > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On

$$Excel-Macros$$ Re:

2009-06-10 Thread harsh shah
name: harsh shah subject : formula reference tip : press ctrl + [ (will show from where the formula has been derived) & ctrl + ] (will show where this cell has been used in formula) On 10/06/2009, Rakesh Sharma wrote: > > > HI All, > > > Name : Rakesh Shar,ma > S

$$Excel-Macros$$ help required -

2009-05-27 Thread harsh shah
hello i want currency to be shown in terms of lacs & crores instead of millions. can anyone provide help on comma presentation ? any add in for that ? -harsh. --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: amt in words in excel add-in

2009-03-31 Thread harsh shah
REQUIRED... 2009/3/30 S.Ashok S.Ashok > Hi Guys, > > What is the password for amt in words in excel add-in. > > Pl reply asap. > > S.Ashok > > > On Tue, Mar 24, 2009 at 12:18 AM, harsh shah wrote: > >> dear all, >> >> i hope these files might be of