Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

SpellNumber ( Amt )

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

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

Kyle Williams - Show more from this author Augusto Digital https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

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

// UPDATED By Kyle Williams 6/29/2019: Simplified formula so it is now easier to read. Let([ L20 = " One Two Three Four Five Six Seven Eight Nine Ten Eleven Twelve Thirteen Fourteen Fifteen Sixteen SeventeenEighteen Nineteen "; G20 = " Twenty Thirty Forty Fifty Sixty SeventyEighty Ninety " ]; If (Int (Amt / 100000); Trim (Middle ( L20; Int (Amt / 100000) * 9 + 1; 9)) & If (Int (Mod (Amt;100000) / 1000); " Hundred "; " Hundred Thousand "); "") & If (Int (Mod (Amt;100000) / 1000); If (Int (Mod (Amt;100000) / 1000) > 19; Trim (Middle ( G20; Int (Int (Mod (Amt;100000) / 1000) / 10) * 7 + 1; 7)) & " " & Trim (Middle ( L20; Mod (Int (Mod (Amt;100000) / 1000); 10) * 9 + 1; 9)); Trim (Middle ( L20; Int (Mod (Amt;100000) / 1000) * 9 + 1; 9))) & " Thousand"; "") & " " & If (Int (Mod (Amt;1000) / 100); Trim (Middle ( L20; Int (Mod (Amt;1000) / 100) * 9 + 1; 9)) & " Hundred "; "") & If (Int (Mod (Amt;100)) > 19; Trim (Middle ( G20; Int (Int (Mod (Amt;100)) / 10) * 7 + 1; 7)) & " " & Trim (Middle ( L20; Mod (Int (Mod (Amt;100)); 10) * 9 + 1; 9)); Trim (Middle ( L20; Int (Mod (Amt;100)) * 9 + 1; 9))) & " and " & Round ((Amt - Int (Amt)) * 100; 0) & "/100" ) Click to copy

// 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

 

Comments

		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, 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 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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 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: