Takes 1 parameter, a formatting mask

Description:

If the existing Database Field value is not blank, formats it as a number, optionally using a custom mask

Mask Options:

• 0 indicates a digit position that will always be shown, even if that value is zero
• # indicates a digit position that will only be shown if it there are enough digits to fill it
• #, at the start of a mask indicates that a , should be inserted every three digits on the left side of the decimal point
• , may also be used in between specified 0s and #s
• . indicates the decimal point position
• % at the end of a mask will multiply the number by 100 and add the % sign

Examples:

[=] 0123.4560
[_#]           '123.456
[_#] 0000.0    '0123.5
[_#] ###0.0    '123.5

[=] ""
[_#] 0.0      'Remains blank instead of resulting in 0.0 as it would with [#]

[=] 123456
[_#] #,.00     '123,456.00

[=] 0.123456
[_#] 0.00%     '12.34%