@ Sajitha

To create a formula to convert numbers into words, you need to work in Visual Basic. I am not an expert in VB. Did some google search and got a solution.

Follow the following steps -

Open a new work book or an existing workbook

Press Alt+F11

Click on Insert and then on module. 

A file is attached containing VB codes, which you need to paste in the window which opens after clicking on module. Close the module. 

Use the formula =Spellword(cell reference)

Hope it satisfies your requirement. 

source - https://excelvbaandmacros.blogspot.in/2011/12/excel-convert-amount-in-words.html

Name Manager

This tool in excel is very useful when we are dealing with voluminous data. For example, You are working in the 15th Worksheet in excel where you want "Sum of amounts/quantities" From the first sheet. Though the formula is simple, to give reference to the first sheet from the 15th sheet is a tedious task.

Here is how name manager helps you -

1. Name manager helps you define a set of cells (either rows or columns or a combination of both (tables) )

2.  To define a set of cells, select the cells which are to be named.

3. Click the name box which is on the left of the formula bar (See attached file for diagram)

4. Type the name which you want the cells to be defined as. 

(In the attached file, I have defined Account Nos as Account and Amounts as Amount. The entire data has been defined as debtors)

When you type =Sum(Am..) in the second worksheet, it suggests Amount as can be seen in attached file. If you type the formula =sum(Amount), it would sum the Amount cells from the “Debtors” sheet. Similarly you can use =Count(Account), which would return the number of accounts from debtors sheet.

Similarly you can use vlookup as =VLOOKUP(A4,Debtors,2,0).

Simple, isnt it? 

Pictorial explanation  and excel sheet is attached in the word file. 

Names can also be defined, added, edited or deleted using the Name Manager option available under the Forumlas section

Query - is there any formula for converting convert small letter into capital and vice versa in ms excel?

________________

Lower, Upper and Proper -

The formula =Lower(cell reference) will convert the text in cell to lower case. if the cell had CIVIL WOrks it would now be civil works 

Similarly the formula =upper(cell reference) will convert text in a cell to upper case. The result would be CIVIL WORKS

The formula =Proper(Cell) will convert first letter of each word in Upper case and remaining letters will be converted to lower case. The result would be Civil Works

To input Current date in a blank Cell - Ctrl+;

To input Current date in a blank cell - Ctrl+Shift+;

To format cells in Number Format - Ctrl+Shift+1 

To fomat cells to Date Format - Ctrl+Shift+3

THANKS FOR SHARING PLEASE KEEP ON SHARING