ParseCurrency ( Amount ; Decimal )
Rate this function: Average rating: 3.8 (13 votes)
Discuss this Custom Function
Andrew Persons, Excelisys
http://www.excelisys.com
Turns numerical currency into the text equivalent
Sample Input:
| ParseCurrency ( "223453.05" , "." ) |
|
Sample Output:
| Two Hundred Twenty-Three Thousand Four Hundred Fifty-Three Dollars and Five Cents |
|
Description:
Updated 7/3/2006: Fixed various bugs.
ParseCurrency() takes a numerical currency and the decimal symbol used ("."; ","; etc.) and returns the long text equivalent. One application of this is for check printing.
It makes use of two other functions, ParseHundreds() and ParseDollars(). To implement this, you need to create the ParseHundreds() function first, then ParseDollars(), and finally create ParseCurrency().
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:
|
Newest Custom Functions:
| 1. |
list.intersect (listA; listB) |
| |
(Mon, May 14, 12:43pm) |
| 2. |
WeekStart ( weekOfYear ; year ) |
| |
(Sat, May 12, 8:42am) |
| 3. |
PercentToWords (FIELD) |
| |
(Thu, May 10, 3:16pm) |
| 4. |
PercentToText (FIELD) |
| |
(Thu, May 10, 2:37pm) |
| 5. |
StripReserved( text ) |
| |
(Wed, May 02, 6:05pm) |
| 6. |
ListBaseTables |
| |
(Wed, May 02, 3:48pm) |
| 7. |
ValidEmail( theEmail ) |
| |
(Wed, May 02, 7:27am) |
| 8. |
UltraDate (Text; LongDate_or_DateDigit) |
| |
(Wed, May 02, 6:07am) |
 |
|
