ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   does Excel 07 allow User Defined functions? (https://www.excelbanter.com/excel-worksheet-functions/243327-does-excel-07-allow-user-defined-functions.html)

doc_grandma

does Excel 07 allow User Defined functions?
 
I'm trying to use a macro to create a SpellNumber function in Excel. I can't
find a User Defined category.
Is there any other way to convert dollar values to words (i.e., 15.50 to
fifteen dollars and fifty cents) - I want to use Excel to write checks.
thanks
doc grandma

David Biddulph[_2_]

does Excel 07 allow User Defined functions?
 
Numbers to words:
a.. http://support.microsoft.com/kb/213360
b.. http://www.xldynamic.com/source/xld.xlFAQ0004.html
c.. http://www.ozgrid.com/VBA/ValueToWords.htm

--
David Biddulph

"doc_grandma" wrote in message
...
I'm trying to use a macro to create a SpellNumber function in Excel. I
can't
find a User Defined category.
Is there any other way to convert dollar values to words (i.e., 15.50 to
fifteen dollars and fifty cents) - I want to use Excel to write checks.
thanks
doc grandma





All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com