Brian Dunning's FileMaker Custom Functions

ParseDollars ( Amount )

Sub-function used by ParseCurrency()

  Average rating: 4.3 (31 votes) Log in to vote

Andrew Persons   Andrew Persons
Excelisys
http://www.excelisys.com

Share on Facebook Share on Twitter

  Sample input:
ParseDollars ( 223453 )
  Sample output:
Two Hundred Twenty-Three Thousand Four Hundred Fifty-Three Dollars

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Updated 4/24/2006: Fixed various bugs.

ParseDollars() is a sub-function used by ParseCurrency(). It also makes use of ParseHundreds() [also listed on this site], which should be entered first.

It takes a currency input of only dollars (not cents) and returns the text equivalent. It is a recursive function.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.