Have a look here:
h
ttp://www.mvps.org/dmcritchie/excel/getstarted.htm
-----Original Message-----
From: MS Excel General Q & A List
[mailto:EXCEL-G PEACH.EASE.LSOFT.COM]On Behalf Of Harmeet
Singh
Sent: Wednesday, September 27, 2006 2:14 PM
To: EXCEL-G PEACH.EASE.LSOFT.COM
Subject: How to add function?
Hi Everybody,
I wanted to add a function wherein i can convert a number
(amount) to
words. I received the code for the same from a friend of
mine but he does
not know how to install it (somebody installed it for him).
Few lines of
the function are given below. Can anybody explain how to add
it (i tried
putting the lines in macros screen, but that does not work)
Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
Dim Dollarss,centss , Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
Place(4) = " Billion "
Place(5) = " Trillion "
Regards,
Harmeet
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|