amount The amount of money (in dollars)
Money Format Checkwriting
Converts a dollar amount into words for a check-writing system.
The text is all lower-case, some people might prefer the output in proper case, which is easy to do:
Proper( ConvertMoneyToWords( 567.87 ) )
It supports more money than you will ever have to write a check for.
ninety-seven billion nine hundred six million three hundred seventeen thousand four hundred thirty-seven dollars and 15/100
Let( [ roundedAmount = Round( amount; 2 ); dollars = Div(roundedAmount;1); cents = (Mod(roundedAmount;1) * 100) ];
If (dollars = 0; "zero"; ConvertIntToWords ( dollars; 10^15 )) & " dollars and "
& If (cents = 0; "no"; cents ) & "/100"
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/129
Prototype: ConvertMoneyToWords( amount )
Function Author: The Shadow (http://www.fmfunctions.com/mid/34)
Last updated: 23 December 2008