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

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.



Log in to post comments.


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

Under construction. Email me your wish list for improvements.