Brian Dunning's FileMaker Custom Functions

SpellNumber ( Amt )

Converts Currency into Text (does not require any other functions)

  Average rating: 4.0 (19 votes) Log in to vote

Kyle Williams   Kyle Williams
Sphere Solar Energy
http://spheresolarenergy.com/

Share on Facebook Share on Twitter

  Sample input:
SpellNumber ( 444.44 )
  Sample output:
Four Hundred Forty Four and 44/100

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

This can be used all by itself without the necessity of any other functions.
Converts Currency into Text which can be very useful if printing paychecks or for paying bills

 

Comments

Sarah   Sarah, IA
Jun 17, 2016
This custom function is very hard to read with no ¶s or white spaces. I am also wondering why nested "If" statements were used vs. using nested "Case" statements?
 
Thomas Hellwig   Thomas Hellwig, Hamburg / Germany
Jun 18, 2016
Please note:
"Function Definition (the function itself):
Please use FileMaker's convention of one space between all terms and separators."

To edit it please click on the link: This is my Custom Function and I want to edit it
 
Lee Smith   Lee Smith
Jun 18, 2016
You can format a calculation using this link
http://www.aptworks.com/cgi-bin/calc_formatter.cgi
 

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.