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 - Show more from this author
Dreamclinic Massage

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)

// UPDATED 6/29/2019: Simplified formula so it is now easier to read.
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



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

Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: