in excel i want to convert figure into words example 124=one hundred twenty four, can somebody tell me how can

Answer 1

See this question, i asnwered it before

http://answers.yahoo.com/question/index;_ylt=Ah1su7zDa7PJN9VMy6FlriUAAAAA?qid=20070131062732AAx73nA&show=7#profile-info-5df7cc6f9f44cefe01289ac252d781e2aa

Enjoy my profile, I am the VBAXLMan

Answer 2

No, there isn't any function in built. But there are many tools that provide such function without any hustle. For example the one mentioned above. Num2Text is also good. But, I prefer to do my own coding. Here's an idea how you can do it with help of if, left and right function. 1. Separate each character in number. 2. Create a table containing word for each number, e.g. one, two, etc. 3. Create a table containing reference to Hundred, thousand, etc. (Tricky part is Eleven to ninety nine) 4. Convert Number to Word by using IF and than attach thousand, hundred etc. 5. There you have it.

Answer 3

Figure Into Words

Answer 4

There isn't a single function to do this.

I've created a spreadsheet that will do this using a lookup (but I've only done it for numbers 0-25, you should see how to expand all the way to 99).

There are no macros in the spreadsheet so you can leave your security on maximum.

To use the spreadsheet, edit the number with the Yellow Background - the words in red will change.

Answer 5

=IF(Cell**=124,"One Hundred and twenty four","")

For slightly advanced users - such as the previous user suggested you can make Excel only run the above formula when instructed by a macro.

Sorry I made a slight mistake to the formula.

Answer 6

Insert an If statement. And here it goes:
=IF(124,"One hundred twenty-four","")

Answer 7

If you like VB, you can use this link to get you started:
http://www.ozgrid.com/VBA/CurrencyToWords.htm
or from Microsoft themselves
http://support.microsoft.com/kb/q213360/

Answer 8

run a VB script.