Price_Format ( price )
Formats a number in text with two decimal places.
Average rating: 4.4 (32 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This take a number in a number field, no matter how many decimal places, and formats it as text with two decimal places. It does not add a currency symbol. It also does not include commas to separate the thousands places. Just a simple little function for those cases where you need a price properly formatted in a text field.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.