Format Number
Returns a string representing the specified number in the specified format.
For example, if Number To Format is 50, and Format is $, the function returns $50.00.
Arguments
This function has the following arguments:
Number To Format: Numeric value specifying the number to be formatted.
Format: Text string specifying the format of the function result. The format can be specified based on the Java format specification, or with the following shorthand:
$ for US dollar money values, $$ for US dollar money values with additional formatting, or () for non-money values, formatted similar to money. Both positive and negative formats can be supplied, for example: #,###;(#,###).
The function returns a text string