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

Under construction. Email me your wish list for improvements.