Complete Text to Display Based on Number

Hi,
Is that possible to auto generate complete text instead of number?
Example :
100
One Hundred.
123
One Hundred Twenty Three

I want a formula that can auto Generate the text based on number we input.
Number to input in A1
In B1 I want the text of the number.
Max 1 Million (1.000.000) or it would be great if it can be unlimited
Any suggestion?

Quite a common question... you will find plenty of examples on line, eg:

http://www.ozgrid.com/VBA/ValueToWords.htm

If you happen to have morefunc.xll installed (3rd party add-in) see NBTEXT function

OK
It's VBA
Thanks
As I don't know anything about VBA
and also wonder from where should I start to learn it