Numbers represented by words

[saniveva]

Hi,
is there a formula, which if I write "100" in cell a1, would result in "one hundred" in cell b1, or if I write "225 687" in one cell, I would get "two hundred twenty five thousand six hundred eighty seven" in another. Basically I need numbers to be represented by words. I write a lot of invoices, where the sum should be written both with numbers and words, and it would be a lot easier for me, if the words come out automatically, when I input the numbers. I need numbers up to 100 000 000.

If there is a possibility for the decimal point for the cents, it would be perfect, but I would be quite happy even without it.

As you can see, I am not a native speaker of the English language, so I apologize if my explanation is not very clear, but I would be very grateful, if you could help me.

Thank you in advance!!!

[shg]

Welcome to the forum.

This requires VBA. See http://www.ozgrid.com/VBA/CurrencyToWords.htm

[Cutter]

There is this from MS:

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

[saniveva]

Hi Guys, it's the same solution in both your answers, and it works, and it's great.

THANK YOU VERY MUCH