How Microsoft Excell can convert figures into words is there any formula?

Shahid Mehmood: How Microsoft Excell can convert figures into words is there any formula?
I want to convert figures into words in Microsoft Excel Application please some body help me, my second question is how some cells can be locked in Microsoft Excel too.

Answers and Views:

Answer by Susan T
I don’t know if or how you can convert numerals into words in Excel: To lock cells;
Select the entire worksheet by clicking the Select All button (the gray rectangle directly above the row number for row 1 and to the left of column letter A).
Click Cells on the Format menu, click the Protection tab, and then clear the Locked check box.

Answer by Hush Lee
Where there is a will there is a way – however, the way would not be with a formula.

If I understand you correctly you want to take an entry, say:

1000

and convert is so that excel displays:

“One Thousand”

This can undoubtably be achieved, but it would need to be done in VBA (Visual Basic for Applications – which is included with Excel and other office applications).

You would need to develop code which primarily scanned how many digits your number had, what each one is, its position within the number and how that would be translated to a word.

This code is likely to be quite complex, and unfortunately I don’t have time to work it out right now.

It is also possible that the VBA API has a function for this already included. However, I am unaware of this function if it exists.

With regards to locking cells, the option to lock a cell in under the Formatting options. For a locked cell to act as locked you must enable ‘protection’ on the work sheet. This is done in different ways depending upon the version of Excel you use, so best to check your version’s Help and search for ‘Protecting Worksheet’.

Answer by Adziwa
You can convert the numbers to words using the Visual Basic code found on the Microsoft Knowledge Base here:

https://support.microsoft.com/kb/213360

This can be easily edited to remove the ‘dollars’ and ‘cents’ text but it is a good starting point. Unfortunately there is nothing already built-in to Microsoft Excel so you have to generate the formula yourself :o(

Regarding locking cells, go to Format->Cells and then the last tab which enables you to tick boxes to hide or lock the cells when the sheet is protected using Tools->Protection->Protect Sheet.

Hope this helps :o)