CurrencyFormatForText ( ValueText )
Translate numbers stored as text into US Dollars (currency)
Average rating: 4.6 (29 votes) Log in to vote
Chester County Intermediate Unit
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.)
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.