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 as a 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
Copyright © 2013
Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.