Is there any function in Excel that converts number into words.?

I think so not possible.

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.

I agree with the two above. You will need to create a function. If you have a known range of numbers it would be easy for you to create one, but numbers can go on forever. Good luck.

Very interesting question, thou.

You will have to create a Function just go to the link and this will help

you have to use the

=spellnumber() function.

the bad news is...1st you have to create the function.

the good news is...its just a copy and paste

heres the vba script from Microsofts Knowledgebase.

if you dont want dollars and cents, then the easiest thing to do is look for the quotes in the Dollars case loop and change "dollars" to "" and same with cents...just play around with it.

good luck

The answer provided by Expletiv is correct.

Use this and carry out your work,

If you are customizing this to indian format,

Post it for others use.

they do not have a formula in excel. i have a designed a custom module. contact me if u want it. it will convert all numbers into words!!! it is easy to use., free, so try it out!

you can type the words in one column and # in the next column then do a vlookup I think that is the on way other than that google it.

its not possible, just type in the long format if you want...

100000