Brian Dunning's FileMaker Custom Functions

Price_Format ( price )

Formats a number in text with two decimal places.

  Average rating: 4.4 (32 votes) Log in to vote

Brian Dunning   Brian Dunning
BrianDunning.com
https://www.briandunning.com

Share on Facebook Share on Twitter

  Sample input:
Price_Format ( 3.1 )
  Sample output:
3.10

  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.

 

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.