how to convert number to words in excel

Recently one of my readers asked me the question how to convert numeric value in to word, This is an important function everybody looking for in excel but unfortunatly there is no ready to use formula, function in excel. however  microsoft provides a visual basic function script in their support section. This script is useful for spelling number in to US dollar.

Accountinghead is converted this function script for the use of indians  with the help of some VB experts.  Letus do it with easy 5 steps , by using this script you can convert number in to indian Rupees.

1. Download the script from here
2. Open excel  then Press Alt+F11 to start visual basic editor
3. In visulal basic editor click insert menu then open module
4. Open the downloaded notpad for script, copy the script and paste in opened module window, on the left side pane  click on This work book
5. Press Alt+Q to save the  file.

Now save the excel workbook on your hard disk. For MSoffice 2007 You need to select Save as type = Excel Macro enabled Work book. In excel 2003 you can directly save as xls file.

You are created a new excel function called ntow

How to use the function Number to word

In excel 2007 you need to enable macros before typing function. As you have saved the work book macro enabled, you can see a warning message  just under the  menu tab like this .

Click on options, a new window appear,click on enable this content.you are done.

Now you have  Rs 1555 in cell A1 and you need the number in words cell A2 type in cell A2  =ntow(a2)

Press enter, the amount in words will have displayed.

If you dont want the rupees element, remove the following code from the script

If Val(Left(FIGURE, 9)) > 1 Then
Ntow = “Rupees ”
ElseIf Val(Left(FIGURE, 9)) = 1 Then
Ntow = “Rupee ”
End If
You can also use this function as
=ntow(1500 ) the number will be converted in to words in the same cell.
Related posts:

I cannot use click and drag feature in excel- how to restore fill handle

Recently one of my readers asked, that he cannot use Microsoft excel ‘click and drag’ feature to fill column and cell .He was using excel in built list and custom list for filling date and month. He was struggling to enter each list by typing manually.
This is a common problem happens to normal excel users. They might have clicked somewhere in the option that he cannot remember and he does not know what will the effect of that unwanted click. The problems caused as user disabled click and drag feature of excel .as a result fill handle disappeared. In this case the excel cell look like a complete square like below

How to restore fill handle and click and drag function

Click on File and locate Options and click on it.

Now Excel option screen will be in front of you, Select advanced tab on the left side.

As you see in the above picture you might have accidently unchecked “Enable fill handle and cell drag and drop” check box .Re-enable it by checking the box.
Just under that there is another option Alert before overwriting cell. This will alert you any data already exist in copying cell while using fill handle.
Related posts:

1.