$$Excel-Macros$$ Shortkey to unhide hidden column

Hi Group, My system got upgraded with Windows 7 Professional. In terms of Shortkeys , Hide and unhide rows (Ctrl+9 & Ctrl+Shift+9 respectively) is working fine. But when it comes to columns While shortkey to Hide coulmn(Ctrl+0) works ...thne Unhide part is not working (Ctrl+Shift+0) Can anyo

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007

m > http://www.openexcel.com > > > On Dec 7, 5:22 pm, Radhe Sham wrote: > > Hi Ashish, > > > > Many thanks for the kind help in providing valuable information about > > Openexcel. > > > > Probably the communicat

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007

gt; (Microsoft Certified Application Specialist) > (Microsoft Certified Professional) > http://www.excelitems.com > http://www.openexcel.com > ____ > > On Dec 7, 2:13 pm, Radhe Sham wrote: > > Hi Group , > > > > The addin for conv

$$Excel-Macros$$ Reqd : Add in to convert Numbet to text in Excel 2007

Hi Group , The addin for converting a number to text which was working in Excel 2003 does not seem to work in Excel 2007 Can anyone kindly help with an add in for Excel 2007 for converting number to text please Thanks and regards Radhe -- --

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

new sheet Kindly do help please Thanks and regards Radhe On Wed, Jun 30, 2010 at 3:58 PM, GAURAV JAIN wrote: > Hi Radhe, > > PFA the attached solution > > Regards, > Gaurav Jain > > > On Wed, Jun 30, 2010 at 2:54 PM, Radhe Sham wrote: > >> Hi An

Re: $$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

which ever month is selected. Hope you'd help in solving this to the next level also Many thanks once again Best regards Radhe On Wed, Jun 30, 2010 at 2:15 PM, Aindril De wrote: > Hi Radhe, > > PFA the attached solution > > Regards, > Andy > > > On Wed, Jun 30, 201

$$Excel-Macros$$ Help reqd for using SUMIF along with a variable (month)

Hi Group I have data which has repeated values for a set of product every month for 12 months Need the output as total for each product ( sumif formula helps here) But the requirement is, in the summary if the month is changed, then the output has to be the sum total for each product for the res

$$Excel-Macros$$ Re : Error "Too many different cell formats"

Hi Group, Its quite often while working on excel files with huge data that while trying to format the sheet pops up an error "Too many different cell formats". Once this pop up appears the required formating cannot be performed be it adding/deleting borders or colors. One way to resolve this is

$$Excel-Macros$$ Re: Managing decimal places

Hi , I have a requirement for a solution regarding the display of decimal place I have a report which displays data in 2 currencies - USD K & INR Crores Based on the Currency selected from the drop box. The Value in the respective currency is required to be displayed in the same cell for exampl

$$Excel-Macros$$ Re: Number in Words

Hi ...may be u could try thisThis file was provided by one of the excel gurus which i have been using..hope it helps u too formula is =text2num(cell ref)..Hope u have included the macro into excel addins On Sat, Aug 8, 2009 at 8:01 PM, Sabyasachi Mishra wrote: > still not working dear > >

$$Excel-Macros$$ Re: Please Number in to Words

Hi Alok, This file was provided by one of the masterminds in the group which i have saved and been using This definately solves ur prob the formula to be used is =num2text(Cell Ref) Regards Radhe On Thu, Jul 30, 2009 at 6:32 PM, Alok Nayak wrote: > > Hi ,Every one > Greeting of the Day >

$$Excel-Macros$$ Re : Retaining date format while concatenating

Hi Group This is a query regarding the date format retention in concatenate What happens is while concatenating some text with a cell containing date, the out put is text with the date in number format whereas ther equirement is date format Output for eg " Today is 40021" ; required out put is T

$$Excel-Macros$$ Macro reqd for Oracle General Ledger Report ( Account analysis (180 Char)

Hi Group , Members working on Oracle E business Suite 11i would be aware that the report generated in oracle is saved in “txt” form. My requirement is with regard to the General Ledger Report generated under request type “ Account Analysis – (180 Char). For analysis purposes , the text f

$$Excel-Macros$$ Re: Need Help regarding split Emp. Name & Emp. ID

Hi Lavprasad Found a simple solution. Hope it helps. Regards Radhe On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote: > > Dear Friends, > > I am downloading the employee data from our portal. In, there is employee > name & Emp. ID both are in the same column. I want to split Emp. Name & Emp

$$Excel-Macros$$ Re: Convert pdf to excel

Hi Chinmay, Request you to kindly forward the software to my id also- radhes...@gmail.com . I am sure it would be of great help Thanks in advance Best regards Radhe On Wed, Mar 18, 2009 at 9:44 AM, nehal sejpal wrote: > > Dear Chinmay, > > Can u send me that program on my id: nehal_c...@rediff