i want any number in ms-excel convert into words (spellings)?

Answer 1

This is a tricky one, there is not a function in Excel that will do this for you, however, it could be done with a bit of programming.

You could possibly do this by using combinations of functions to convert the number into a string, count the length of it and output each section of the string as a defined word followed by the appropriate level of the number (i.e. "Thousand"), however, as you can only nest up to 7 functions in Excel, you will have big problems when it comes to defining words for ten different digits.

Try asking Mr Excel http://www.mrexcel.com/ this is the best site on the net for Excel answers.

Answer 2

You have to write in VBA a function. The best way is to split the number in three digits, beginning fro the end to the front.
Then you set the words returned from the function together.
When you can not fix it on your own, just contact me under [e-mail] I did it already once

Helmut

Answer 3

when typing the number put a ' before it. It won't be displayed and the numbers you type will stay in the format you type them.

To test it try typing 017 in a cell and it will reformat to 17. Put '017 and it will display 017.

Answer 4

Create yourself a macro it will only take 5 minutes and you will be right to go!

Answer 5

You'll probably need to write a bit of VB script.

Answer 6

You can use a look up table for that function.

Answer 7

42 = forty two

Answer 8

Try...

http://www.xldynamic.com/source/xld.xlFAQ0004.html

...u will find it useful.

Answer 9

What do you mean?

Can you be more specific?

Answer 10

100000