Format Predefined Number
Description:
The following predefined number formats may be used with the Format function. Predefined formats may not be combined with user defined formats or other predefined formats.
Form Description
General Number
Return number as is.
Currency Same as user defined number format "$#,##0.00;($#,##0.00)"
Not locale dependent at this time.
Fixed Same as user defined number format "0.00".
Standard Same as user defined number format "#,##0.00".
Percent Same as user defined number format "0.00%".
Scientific Same as user defined number format "0.00E+00".
Yes/No Return "No" if zero, else return "Yes".
True/False Return "True" if zero, else return "False".
On/Off Return "On" if zero, else return "Off".
Example: