Numaric to Inword in excel by VB

Hi i am using below formula for convert Numeric to In-word in Excel- Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber) Dim Dollars, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " ...

Message posted on the October 17th, 2012 - 3:21 AM ET

Conversion from Number to Word!! Aki

Dear Team, I have the below mentioned code. I have a Number as 501123.83 in a cell (E2). If I put =spellNumber(E2) It is giving me a value as RUPEES FIVE HUNDRED ONE THOUSAND ONE HUNDRED THIRTY THREE AND EIGHTY THREE PAISE ONLY I wanted a value ...

Message posted on the February 01st, 2012 - 02:24 pm ET

Display Numbers as Words

I have found plenty of answers for this including an old post from 2004 at http://tinyurl.com/4m4sp, and Microsoft's website (http:// support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360) however, they all translate the number into currency. How ...

Message posted on the December 01st, 2011 - 12:54 am ET

Auto Enable Macro

I download SpellIndian function by Yogi Anand from anandent.com, for my invoice template, I insert code in to VBE standard module. Now I want to automate the code i.e. when I open worksheet it is auto enable and when I close worksheet it is automtic ...

Message posted on the March 04th, 2010 - 01:19 am ET

"Convert Currency to Words in Indian Style"

I download SpellNumber in to visual basic but it not execute properly, can someone help whith this issue. I am not a programmer. excel2003. my email: atiq8961@yahoo.com Thanks in advance.

Message posted on the February 21st, 2010 - 10:15 am ET

Converting currency to text and spliting to two lines

I have mangaged trough a google search to get the code to convert currency in cell to text in another for printing cheques etc. The problem is that once the text exceeds 40 characters i need it to go onto another line. Can someone please advise ...

Message posted on the January 16th, 2010 - 02:04 pm ET

Is spellnumber function no more available in MS office 2007?

I used to have VBA function spellnumber to convert number to text in MS Excel 2003. However, in MS Office Excel 2007, this spellnumber function is no long valid and it gives me #Name error on the cell. How can I fix it???

Message posted on the January 06th, 2010 - 08:54 pm ET

Excel Spellnumber Formula

Hi Everybody, I am using 2003 version excel and have a page set up with a code that lets me use the formula Spellnumber. The problem is that when a user with Vista 2007 version opens the file up the formula does not work. Any ideas that will let ...

Message posted on the October 02nd, 2009 - 12:55 am ET

does Excel 07 allow User Defined functions?

I'm trying to use a macro to create a SpellNumber function in Excel. I can't find a User Defined category. Is there any other way to convert dollar values to words (i.e., 15.50 to fifteen dollars and fifty cents) - I want to use Excel to write ...

Message posted on the September 21st, 2009 - 06:05 pm ET

convert the number to Arabic word

I prepared module for spellnumber to convert the number to Arabic words, so when I view the module It is showing me unreadable letter in report or query,. Please help thanks

Message posted on the June 15th, 2009 - 10:42 am ET

User Defined Function use any worksheet

I downloaed SpellNumber, into visual basic, which converts numbers to text from online. It works fine in the one workbook, i loaded it to. But the function doesn't appear available if i open another workbook. Is there something I need to turn on ...

Message posted on the April 01st, 2009 - 10:25 am ET

putting two functions together

I am using a function called SpellNumber =SpellNumber(J28) ... to automatically enter a dollar amount in words, and it works just fine. But I want to place two asterisks (**) before and after those words. So I tried using the CONCATENATE formula ...

Message posted on the January 05th, 2009 - 07:05 am ET

		Advanced search
In