PC Review


Reply
Thread Tools Rate Thread

Convert Number To Word ?

 
 
Eng Teng
Guest
Posts: n/a
 
      14th Jun 2008
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

 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      14th Jun 2008
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



 
Reply With Quote
 
Niek Otten
Guest
Posts: n/a
 
      14th Jun 2008
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
|


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert number to word =?Utf-8?B?UktT?= Microsoft Excel Misc 3 12th Apr 2007 11:47 AM
convert number to word =?Utf-8?B?aGl0ZXNo?= Microsoft Excel Misc 1 5th Sep 2006 09:08 PM
Convert Number to Word Rup Microsoft Excel Discussion 3 22nd Aug 2006 08:38 AM
want to convert number to word (eg) 1 as one S.Ramanujam Microsoft Excel Discussion 4 28th May 2004 08:54 AM
who can't convert one number y number word draco Microsoft Excel Programming 1 5th Oct 2003 10:45 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:09 AM.