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:
Sub Main
Debug.Print Format$(2.145,"Standard")
' 2.15
End Sub