Convert Number To Word ?

[Eng Teng]

How do I write a function to convert Number to word ?

Example: 1234.45 is One Thousand Two Hundred Thirty Four And Cents Forty
Five Only.


Regards,
Tee

 

[Bob Phillips]

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

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Niek Otten]

Hi Tee,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I write a function to convert Number to word ?
|
| Example: 1234.45 is One Thousand Two Hundred Thirty Four And Cents Forty
| Five Only.
|
|
| Regards,
| Tee
|