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

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)



"Eng Teng" <(E-Mail Removed)> wrote in message
news:OR%(E-Mail Removed)...
> 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

Hi Tee,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Eng Teng" <(E-Mail Removed)> wrote in message news:OR%(E-Mail Removed)...
| 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
|