FormatNumber is a one-pass FileMaker Pro custom function that formats a number using intuitive, free-form format options that completely mimic FileMaker Pro’s number data type formatting. Formatting options can also be specified via escaped options. Returns text string of number in the requested format.<\/p>\n
Passing ‘?’ as the only content of ‘format’ returns a shortened version of this text.<\/p>\n
Minus sign, credit and delta symbols can be displayed on the left or right of the formatted number by placing them to the left or right of an included decimal separator, or zero, in ‘format’. Negative signs are placed at their default location when no decimal separator is included.<\/p>\n
Percent, currency and other notations can be placed on either side of the formatted number depending on whether you place them at the left or right of an included decimal separator, or zero, in ‘format’. Notations are placed at their default position when no decimal separator is included. The user must insure that the notations in ‘format’ produces the desired formatted result.<\/p>\n
Escaped options override free-form format, defaults and add formatting. Enclose each option with escape (backslash) characters \\\\\\\\.<\/p>\n
Revised February 11, 2014. Added code to process numbers input in scientific notation format and to return numbers in scientific and engineering notation format. Reformatted the boolean separator to be two pipe characters and added escape options to allow setting Boolean positive and negative values. Optimized the code to remove redundancies, decrease the overall size, and speed up processing. Restructured the help text to make it more concise so that it can be used easier in tool tip popups. Also, added code to determine system decimal and thousands separators.<\/p>\n
FormatNumber code:<\/strong> Copy the selected code (click on Select All to highlight all the code) to the clipboard and paste it into a newly created Custom Function. Download code as a text file from here.<\/a><\/p>\n