MoneyToWords2 ( NumberField )
Calculate a number into words - modification
Average rating: 4.7 (31 votes) Log in to vote
Tim Anderson Group
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Modification of Don Wieland's CF to include an 'and' after hundreds where appropriate.
Thanks for the original Don.
Updated Aug 10th 2006. error in formula for numbers over a million, plus now gives :
Seven Million, Six Hundred and Fifty Four Thousand and Twenty One pounds
Seven Million, Six Hundred and Fifty Four Thousand, Twenty One pounds
Better for those of us in the UK!
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.