Brian Dunning's FileMaker Custom Functions

NumberToTextFormatCurrency ( Number ; Seperator ; DecimalSign ; Precision )

Format numbers to text numbers

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

Louk Burggraaf   Louk Burggraaf
Burggraaf it
http://www.burggraaf.nl

Share on Facebook Share on Twitter

  Sample input:
NumberToTextFormatCurrency ( "12345,51" ; "," ; "." ; 3 )
  Sample output:
12,345.510

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

When you need your curreny (or other) in a text field or several in numbers multiple lines in a (calculated) text field.

 

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.