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

2010-12-07 Thread Radhe Sham
Hi Ashish, Many thanks for the kind help in providing valuable information about Openexcel. Probably the communication from my side was not clear The help i was seeking was to convert the value to be mentioned in words For example if a cell has 523.25; this value should be displayed in words

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

2010-12-07 Thread OpenExcel.com
Hi Radhe, 1. Download Open Excel from http://www.openexcel.com 2. Install it 3. Open your Workbook. 4. Go to 'Open XL' tab. 5. Go to 'Number Utils' 6. Click on 'Spell Numbers' and you're done. It does exactly what you mentioned and have around 100 more useful utilities, you probably would be

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

2010-12-07 Thread Manoj kumar
Try this link out... http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html Regards, Manoj Vishwakarma On Tue, Dec 7, 2010 at 5:52 PM, Radhe Sham radhe2...@gmail.com wrote: Hi Ashish, Many thanks for the kind help in providing valuable information about

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

2010-12-07 Thread Radhe Sham
HI Ashish , Sorry to trouble you again Spell Numbers convers the number into words in the same location while what is requires is the numbers are to be translated into words in a different location. I have attached a file with the format in which the numbers are requires to be mentioned in words

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

2010-12-07 Thread Ms-Exl-Learner .
You can use substitute in front of the UDF to replace the word to your desired local currency right. Another Method:- Follow the below link and download the MoreFuction Addin from that and run the setup. http://download.cnet.com/Morefunc/3000-2077_4-10423159.html After doing that open excel

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

2010-12-07 Thread Manjunath C
Hi, I am unable to download the OPEN XL, can any one help the procedure On Tue, Dec 7, 2010 at 5:52 PM, Radhe Sham radhe2...@gmail.com wrote: Hi Ashish, Many thanks for the kind help in providing valuable information about Openexcel. Probably the communication from my side was not clear