Brian Dunning's FileMaker Custom Functions

MoneyToWords2 ( NumberField )

Calculate a number into words - modification

  Average rating: 4.7 (31 votes) Log in to vote

Tim Anderson   Tim Anderson - Show more from this author
Tim Anderson Group

Share on Facebook Share on Twitter

  Sample input:
MoneyToWords2 ( 7654021.05 )
  Sample output:
Seven Million, Six Hundred and Fifty Four Thousand and Twenty One pounds and Five pence

  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
rather than:
Seven Million, Six Hundred and Fifty Four Thousand, Twenty One pounds

Better for those of us in the UK!

 

Comments

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: