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

2009-10-09 Thread Radhe Sham L
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

2009-08-08 Thread Radhe Sham L
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

2009-07-30 Thread Radhe Sham L
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

2009-07-27 Thread Radhe Sham L
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)

2009-05-08 Thread Radhe Sham L
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

2009-04-13 Thread Radhe Sham L
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

2009-03-18 Thread Radhe Sham L
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