Possible format values:

Padding and Flags:

• =f - Specifies the character (f) to be used as padding (Example: %=t this uses "t" as padding). Default is space
• ^ - Removes the use of grouping characters
• + or ( - Specifies how to show positive and negative numbers. If "+" is used, the local setting for + and - will be used (usually a sign in front of negative numbers, and nothing in front of positive numbers). If "(" is used, negative numbers are enclosed in parenthesis. Default is "+"
• ! - Stops the use of currency symbols in the output string
• - If "-" is used, all fields are left-justified. Default is right-justified

Field width:

• x - Specifies the minimum field width (x). Default is 0
• #x - Specifies the maximum number (x) of digits expected to the left of the decimal point. This is used to keep formatted output aligned in the same columns. If the number of digits are bigger than x, this specification is ignored
• .x - Specifies the maximum number (x) of digits expected to the right of the decimal point. If x is 0, the decimal point and the digits to its right will not be shown. Default is local settings

Conversion characters:

• i - The number is formatted to international currency format
• n - The number is formatted to national currency format
• % - Returns the % character

Note: If multiple format values are used, they must be in the same order as shown above.

Note: This function is affected by local settings.