[#] Format (Top Query)

Takes 1 parameter, a formatting mask

Description:

Formats as a number, optionally using a custom mask

Mask Options:

Examples:

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

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

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