Returns a string formatted according to instructions contained in a format String expression.
Format
FORMATVALUE( Value USING Format )
Remarks
Formats the Value using the format specified by the Format argument, and returns the result as a String.The Value argument can be any type of expression. The Format argument can be any character string expression.
For a description of the options allowed in the Format argument see Define a Custom Value Format.
Example:
FORMATVALUE( 12.5 USING '#0.0000' ) returns '12.5000'
FORMATVALUE( DATE '2006-08-02' USING 'EEEE, MMMM d, yyyy' ) returns 'Wednesday, August 2, 2006'
FORMATVALUE( 1000000 USING '#,###' ) returns '1,000,000'
FORMATVALUE( 1000000 USING '0E0' ) return '1E6'