Coversion of numbers into words 
Author Message
 Coversion of numbers into words

Hello,
In one of my spreadsheets I need to convert number into words (for example
$125.10 into One Hundred and Twenty Five Dollars and 10 cents). Is anyone aware
of an excel function or code that can do this ? Your suggestions are much
appreciated.

Abraham



Thu, 18 Sep 2003 01:32:04 GMT  
 Coversion of numbers into words
Hi,

No never heard of it. It would be a nice challenge to write one though.
Shouldn't be too difficult. Let me know when you want me to try it.

Kind Regards,

Gerrit-Jan Linker


Hello,
In one of my spreadsheets I need to convert number into words (for example
$125.10 into One Hundred and Twenty Five Dollars and 10 cents). Is anyone
aware
of an excel function or code that can do this ? Your suggestions are much
appreciated.

Abraham



Thu, 18 Sep 2003 03:04:35 GMT  
 Coversion of numbers into words

Hi,

I have found this function once (somewhere on the net).
Import the module ConvertNrToTxt.bas in your workbook.
The function is called SpellNumber()
I was actually looking myself for a similar function which does the same in Dutch.

Kristin

Quote:
-----Original Message-----

Hello,
In one of my spreadsheets I need to convert number into words (for example
$125.10 into One Hundred and Twenty Five Dollars and 10 cents). Is anyone aware
of an excel function or code that can do this ? Your suggestions are much
appreciated.

Abraham

.

  ConvertNrToTxt.bas
4K Download


Sat, 04 Oct 2003 18:07:06 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Insert a random number number into a pre-designed Word doc

2. Word version number for Word 2000

3. Data Type Coversion Error

4. Help! Image Coversion

5. microsoft excel 4.0 macros coversion to excel 5.0 macros

6. Coversion Problem Decimal Sep. with ADO

7. Help! Image Coversion

8. Coversion of System Colors to true colors

9. American/English coversion

10. Graphics Coversion

11. Convert Numbers to Words

12. Converting numbers to words

 

 
Powered by phpBB® Forum Software