Brian Dunning's FileMaker Custom Functions

CurrencyFormatForText ( ValueText )

Translate numbers stored as text into US Dollars (currency)

  Average rating: 4.6 (29 votes) Log in to vote

John Shields   John Shields
Chester County Intermediate Unit

Share on Facebook Share on Twitter

  Sample input:
CurrencyFormatForText ( 23.1 )
  Sample output:

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

When you need to display a number as text, you will lose the ability to format for currency. This will let you maintain the formatting.

If referencing a whole number, ".00" will be added. If only 1 decimal, "0" will be added to the end. Also, the dollar sign will be added by default. (Can easily be modified to accommodate any currency symbol.)



Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.